Support for MySQL - Syntax highlighting

Spider supports the creation of queries in several ways. You can use the SQL Query Wizard or the Database Export Wizard, or you can create queries manually. If you are retrieving data from a single table, you do not even need to color code its syntax.

The matter gets more complicated, however, when the query covers data from many fields of different tables using different join methods, functions, etc. In this case, coloring the query keywords (operators, statements, functions) can be very convenient. Spider provides a SQL query code coloring scheme in three variations:
  • MySQL
  • PostgreSQL
  • SQL (standard)

If you create a query in a new document, it is very useful to be able to execute it using the "Execute commands from current document" command located in the pop-up menu of the "Database Name" branch on the database structure tree on the MySQL Inspector tab.

You can also customize syntax highlighting. Use these tools for that:

  • Highlighting scheme editor - allows you to edit the highlighting scheme, i.e. add new features, etc. Use it with caution when changes cannot be undone
  • Program settings - syntax highlighting - allows you to adjust the syntax highlighting scheme, but without affecting the scheme itself. Changes can be reverted to the default state at any time. You can also use this window to assign file name extensions for which the scheme should be the default one.

Related topics

To top