.setup.sqlis recommended, as the
.at the start of the filename will cause the file to be hidden from the end user (it will still be visible in the Creator).
sudo mysqlinto the terminal to load a MySQL prompt. From there, if you're using the above example file, you can type the following to test the database:
company_db. You can then create a file for the user to write their query in (e.g.
query.sql) and query the database using the commands typed in there, as shown below:
USEstatement when using the SQL Results Viewer, as the earlier configuration sets this automatically.