MySQL¶
Install dependencies for Ibis’s MySQL dialect:
pip install ibis-framework[mysql]
Create a client by passing a connection string or individual parameters to
ibis.mysql.connect()
:
con = ibis.mysql.connect(url='mysql+pymysql://ibis:ibis@mysql/ibis_testing')
con = ibis.mysql.connect(
user='ibis',
password='ibis',
host='mysql',
database='ibis_testing',
)
API¶
The MySQL client is accessible through the ibis.mysql
namespace.
Use ibis.mysql.connect
with a SQLAlchemy-compatible connection string to
create a client.
|
Create an Ibis client located at user:password`@`host:port connected to a MySQL database named database. |
|
Connect to a database called name. |
|
List tables/views in the current or indicated database. |
|
Create a table expression that references a particular a table called name in a MySQL database called database. |