MySQL

Set up a MySQL connection

When inside a workbook, click View > Databases, then click the + icon and follow the on-screen instructions.

Create a MySQL connection

For detailed instructions, see Connect your data to DataLab.

If you want to experiment with MySQL without setting up a connection, you can use our sample database with employees data (source).

Query the database

You can now query your MySQL database with a SQL cell. Select it in the Select source dropdown in the top left corner of a SQL cell, or select the sample MySQL database.

Example of a SQL cell using the employees-test database connection. The query result is available as employees_df.