5.14. MySQL Connector

    To configure the MySQL connector, create a catalog properties filein named, for example, mysql.properties, tomount the MySQL connector as the mysql catalog.Create the file with the following contents, replacing theconnection properties as appropriate for your setup:

    You can have as many catalogs as you need, so if you have additionalMySQL servers, simply add another properties file to etc/catalogwith a different name (making sure it ends in .properties). Forexample, if you name the property file , Prestowill create a catalog named sales using the configured connector.

    If you have a MySQL database named web, you can view the tablesin this database by running SHOW TABLES:

    You can see a list of the columns in the table in the web databaseusing either of the following:

    If you used a different name for your catalog properties file, usethat catalog name instead of mysql in the above examples.

    The following SQL statements are not yet supported: