Preferences

Document Defaults

The document preferences allow you to adjust the default settings of a new document. For an existing document, these values are adjusted in settings. The options are pictured below:

Auto save on close

If this option is checked, your documents will be saved each time you close them. Otherwise, you will be prompted to either save or discard your changes when you close a document or quit the application.

Show Query Execution Time

If this option is checked, the execution time of a query will be displayed along with the row count in the Query Maker. The execution time is measured from the time MacSQL sends the query to the database plugin for processing until a basic result set structure is returned. This does not include the time it takes to retrieve any row data or the time to display the results.

Crop column titles

When displaying query results in the Query Panel console, each column is as wide as the maximum width or the length of the column name, whichever is larger. If this preference is enabled, the column width will always be the length necessary to display the results—the column title will be cropped to fit if it is larger. (For example, the title of a 1 character column named "Gender" would be cropped to "G".

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

If this option is checked and a document is connected to a MySQL server, all dates will be displayed in the specified format instead of in the system format.

Display Nulls as:

This option allows the user to display null data fields as null (no value) or as an empty string data type.

Recent Queries Size

Allows the user to set the maximum number of recent queries that will be automaticlly saved.