Verify that the query runs and retrieves the right data from the database. Click "OK." When you set up the database query in the data reader, make sure you use MySQL syntax, not MSSQL syntax.

I have a MySQL table that has events ... table aliases - the "e" in this example to make it obvious what table a column is coming from. Besides making your query more readable, it ensures the ...

Click "Finish" to load the data into a new spreadsheet. This example uses a simple MySQL query to illustrate the use of the INTO OUTFILE, FIELDS TERMINATED BY and LINES TERMINATED BY query modifiers.

The whole MySQL database creation script runs out of steam before it even starts. The main issue at hand in this scenario is an old dialect class that’s incompatible with the MySQL installation. A ...