<html> <head> <title>Sequel Pro Help - Performing Custom Queries</title> <meta name="AppleTitle" content="Performing Custom Queries"> <meta name="AppleFont" content="Lucida Grande"> <meta ROBOTS="robots" CONTENT="anchors"> </head> <body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0"> <font face="Lucida Grande,Geneva,Arial"> <br> <table border="0" cellpadding="0" cellspacing="0" width="100%" height="80"> <tr> <td align="left" valign="top" width="70"> <img src="sequel-pro_logo.jpg" width="60" height="60" border="0"> </td> <td align="left"><h1>Performing Custom Queries</h1> </td> </tr> <tr> <td colspan="2"> <img src="bar.gif" width="100%" height="20"> </td> </tr> </table> <br> <font size="-1"> <a href="../index.html">Back to the main menu</a> <br> <br> In order to perform a SQL query you must first choose the "Custom Query" tab. <br> <br> <table border="0" cellpadding="5" cellspacing="0" width="100%"> <tr> <td bgcolor="#fff8dc" valign="top"> <font size="-1" face="Lucida Grande,Geneva,Arial"> <ul> <li>Enter your query and click on the "Run Query" button.</li> <li>The result, if there is one, is displayed in the bottom view.</li> <li>Under "Last Error Message" you can see the last error message returned by MySQL, if there is one.</li> <li>Add your query to the favorites or select a favorite query with the favorites pop-up-button.</li> <li>Select one of the last 20 queries with the history pop-up-button.</li> <li>You can perform custom queries out of your favorite text editor by using the services menu (Services > Sequel Pro > Perform selection as MySQL query). Sequel Pro uses the last opened window to perform the query.</li> <li>If you perferm a query out of a different text editor, be sure that Sequel Pro is already loaded and has at least one window open.</li> </ul> </td> </tr> </table> </font> </body> </html>