Performing Custom Queries

 Back to the main menu

 In order to perform a SQL query you must first choose the "Custom Query" tab.

  • Enter your query and click on the "Run Query" button.
  • The result, if there is one, is displayed in the bottom view.
  • Under "Last Error Message" you can see the last error message returned by MySQL, if there is one.
  • Add your query to the favorites or select a favorite query with the favorites pop-up-button.
  • Select one of the last 20 queries with the history pop-up-button.
  • You can perform custom queries out of your favorite text editor by using the services menu (Services > CocoaMySQL > Perform selection as MySQL query). CocoaMySQL uses the last opened window to perform the query.
  • If you perferm a query out of a different text editor, be sure that CocoaMySQL is already loaded and has at least one window open.