Options

Here you can customize options to make using MacSQL easier and more suited to your needs.

General options

Auto Save on Close

Automatically saves a copy of the current document when MacSQL or the document is closed.

Sort Database/Tables by Name

Sorted tables appear in alphabetical order instead of vendor default. Select the Case Sensitive option to have table names listed alphabetically and grouped by case.

Query History Size

Set the number of queries that are saved in the query history. Default is 10. Valid range is 1-999.

Query Maker Options

Show Query Execution Time

Displays the query execution time in the Query Maker after a successfully executed query.

Crop Column Titles

For queries whose results are displayed as text in the Query Maker, crops the length of column titles down to match the maximum length of the data displayed. For example, if a varchar(2) column named Department was returned, by default MacSQL would make that column 10 characters wide so the title would fit. With this option enabled, the column would be displayed as 2 characters and the title would appear as "De".

Force MySQL dates to 'YYYY-MM-DD HH:MM:SS'

MySQL allows for the input of partial date/time types. For example a user can enter just the Year and Month and leave the Day as NULL. This can cause problems since there is no such thing as Day 0. Selecting this option will force incomplete MacSQL data/time types into full date time types.

Display nulls as:

If a row has a null element, you can select whether MacSQL should display this as "NULL" or an empty string (only affects text results in the Query Maker).