<html> <head> <title>Sequel Pro Help - Data Management</title> <meta name="AppleTitle" content="Data Management"> <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>Data Management</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 view, add, modify, or change data (rows) in your database tables you must either be in the "Content" tab or the "Custom Query" tab. <br> <br> <b>Adding and editing fields</b> <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>Add or remove entries with the plus- and minus-buttons. You can select more than one entry and remove them together.</li> <li>Edit entries by double-clicking on the value you want to change. If the button with the three lines on it is clicked, double clicking on a value opens a sheet where you can edit it. This is preferred to edit large entries or entries with multiple lines.</li> <li>Use the value specified in the preferences (NULL by default) to enter NULL-values.</li> <li><font color="red">Changes aren't written to the database until you deselect the row!</font></li> <li>It is recommended that you edit only tables which have a primary key.</li> </ul> </td> </tr> </table> <br> <br> <b>Sorting and filtering the table content</b> <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>To sort a table by a field, click on the header of the appropriate column in the content-view.</li> <li>Click on it twice to sort the table in descending order.</li> <li>Select a field and operator and enter a keyword to filter a table. Click on the Show All-button to disable filtering.</li> <li>As wildcards use % and _ (% matches any number of characters, even zero characters; _ matches exactly one character)</li> <li>If you have selected "Limit result..." in the Preferences, you can specify the first row to be returned and hit "Go".</li> </ul> </td> </tr> </table> <br> <br> <b>Binary Data (Images, Strings, Hex Representations)</b> <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>Field type should be Blob or Longblob</li> <li>To edit/enter the data, double select the field in the Content tab</li> <li>Click on Open and load an image</li> <li>Change to image and hex view</li> </ul> </td> </tr> </table> </font> </body> </html>