diff options
Diffstat (limited to 'Resources/Help/topics')
| -rw-r--r-- | Resources/Help/topics/bar.gif | bin | 0 -> 184 bytes | |||
| -rwxr-xr-x | Resources/Help/topics/connect.html | 59 | ||||
| -rw-r--r-- | Resources/Help/topics/connect.jpg | bin | 0 -> 6812 bytes | |||
| -rwxr-xr-x | Resources/Help/topics/console.html | 48 | ||||
| -rwxr-xr-x | Resources/Help/topics/data.html | 92 | ||||
| -rwxr-xr-x | Resources/Help/topics/dump.html | 93 | ||||
| -rwxr-xr-x | Resources/Help/topics/encoding.html | 73 | ||||
| -rwxr-xr-x | Resources/Help/topics/preferences.html | 58 | ||||
| -rw-r--r-- | Resources/Help/topics/preferences.jpg | bin | 0 -> 8025 bytes | |||
| -rwxr-xr-x | Resources/Help/topics/query.html | 58 | ||||
| -rwxr-xr-x | Resources/Help/topics/reference.html | 212 | ||||
| -rwxr-xr-x | Resources/Help/topics/sample_query.html | 81 | ||||
| -rwxr-xr-x | Resources/Help/topics/sample_tables.html | 374 | ||||
| -rw-r--r-- | Resources/Help/topics/sequel-pro_logo.jpg | bin | 0 -> 1932 bytes | |||
| -rwxr-xr-x | Resources/Help/topics/syntax.html | 49 | ||||
| -rwxr-xr-x | Resources/Help/topics/tables.html | 89 |
16 files changed, 1286 insertions, 0 deletions
diff --git a/Resources/Help/topics/bar.gif b/Resources/Help/topics/bar.gif Binary files differnew file mode 100644 index 00000000..f716f3f9 --- /dev/null +++ b/Resources/Help/topics/bar.gif diff --git a/Resources/Help/topics/connect.html b/Resources/Help/topics/connect.html new file mode 100755 index 00000000..2fbe0864 --- /dev/null +++ b/Resources/Help/topics/connect.html @@ -0,0 +1,59 @@ +<html> +<head> +<title>Sequel Pro Help - Connecting to a Database</title> +<meta name="AppleTitle" content="Connecting to a Database"> +<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>Connecting to a Database</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 work with a database and its tables, you must first be connected to it. The database connection screen appears at the start of the program. +<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 at least the host (IP or domain name). To connect to a local database, enter localhost or 127.0.0.1 as host.</li> + <li>If you enter a database, it will be selected when the connection to the server is established. Otherwise you can select one of the databases on the server afterwards.</li> + <li>If you enter no port, Sequel Pro uses the default port.</li> + <li>Choose "Save to favorites..." in the favorites popup-button to save a connection. Passwords are stored in the Keychain. To edit favorites open the Preferences.</li> + <li>You can connect to multiple databases by opening a new window (Menu File > New)</li> + </ul> + </td> + <td width="255" valign="top" align="center"> + <img src="connect.jpg" width="220" height="199" border="0"> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/connect.jpg b/Resources/Help/topics/connect.jpg Binary files differnew file mode 100644 index 00000000..e9c1ab6e --- /dev/null +++ b/Resources/Help/topics/connect.jpg diff --git a/Resources/Help/topics/console.html b/Resources/Help/topics/console.html new file mode 100755 index 00000000..1269dc38 --- /dev/null +++ b/Resources/Help/topics/console.html @@ -0,0 +1,48 @@ +<html> +<head> +<title>Sequel Pro Help - Actions Console</title> +<meta name="AppleTitle" content="Actions Console"> +<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>Console</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> + + The Console at the bottom of Sequel Pro lists all of the actions you made in the current session accompanied by a timestamp. +It can be shown or hidden using the toolbar icon at the top that says "Show/Hide Console". You can also clear +the console by using the "Clear Console" button. If those two icons are not located in your toolbar then right-click +in the toolbar area and select "Customize Toolbar..." from the menu. You should then see a window +of icons which you can add to your Sequel Pro toolbar including the two mentioned above. +<br> +<br> + +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/data.html b/Resources/Help/topics/data.html new file mode 100755 index 00000000..14aaeb9f --- /dev/null +++ b/Resources/Help/topics/data.html @@ -0,0 +1,92 @@ +<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>
\ No newline at end of file diff --git a/Resources/Help/topics/dump.html b/Resources/Help/topics/dump.html new file mode 100755 index 00000000..99123b69 --- /dev/null +++ b/Resources/Help/topics/dump.html @@ -0,0 +1,93 @@ +<html> +<head> +<title>Sequel Pro Help - Data Dumps</title> +<meta name="AppleTitle" content="Data Dumps"> +<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 Dumps</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 actions with data dumps, you must use the "File->Import; File->Export" menu options of Sequel Pro. A variety +of exports/dumps can be performed: Sequel Pro dump, Export of Table Content Results (csv or xml format), Export of Custom +Query Results (csv or xml format), or Export of Multiple Table data (csv or xml format). On the other hand, you can only import a +Sequel Pro dump or a CSV file. +<br> +<br> +<b>CSV File Format Information</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>You can choose the following characters: fields enclosed, fields terminated, escaped and line ends</li> + <li>The following characters are escaped: the escaped-character itself, the line ends character, the enclosed character (if given) and the fields terminated character if no enclosed character is given</li> + <li>NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.</li> + <li>When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)</li> + <li>The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer). </li> + </ul> + </td> + </tr> +</table> + +<br> +<b>Importing Dumps</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>Choose "File->Import" from the Sequel Pro Menu</li> + <li>You must choose to import a CSV file (table data) or a Sequel Pro dump (varied information)</li> + </ul> + </td> + </tr> +</table> + + +<br> +<b>Excel CSV Formatting Options</b> +<br> +If you wish to export data to a CSV file for use in Excel, use the following settings: +<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>Enclosed by: " (single quote)</li> + <li>Escaped by: " (single quote)</li> + <li>Line ends: \r (for Macs)</li> + <li>Delimiter: , (comma)</li> + </ul> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/encoding.html b/Resources/Help/topics/encoding.html new file mode 100755 index 00000000..adaed683 --- /dev/null +++ b/Resources/Help/topics/encoding.html @@ -0,0 +1,73 @@ +<html> +<head> +<title>Sequel Pro Help - Text Encoding</title> +<meta name="AppleTitle" content="Text Encoding"> +<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>Text Encoding</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> + + You may choose the type of encoding for the data (text) that is stored in your MySQL database. There are two +places to choose the encoding: the Preferences pane or the encoding pull-down bar at the bottom left of the application window. There +are over 20 encodings for you to choose from. +<br> +<br> +<b>In the Preferences Pane</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>Open up the "Preferences Pane" of Sequel Pro</li> + <li>From the pull-down at the bottom left of the preferences window, labelled "Default Encoding", choose an option.</li> + <li>The encoding you choose will be the default encoding for all future databases</li> + </ul> + </td> + </tr> +</table> +<br> +<b>In the Application Window</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>In the main application window there will be a pull-down at the bottom left of the window labelled "Encoding".</li> + <li>From the pull-down choose an encoding option.</li> + <li>The encoding you choose will be the default encoding for all future databases</li> + </ul> + </td> + </tr> +</table> + +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/preferences.html b/Resources/Help/topics/preferences.html new file mode 100755 index 00000000..0350d76b --- /dev/null +++ b/Resources/Help/topics/preferences.html @@ -0,0 +1,58 @@ +<html> +<head> +<title>Sequel Pro Help - Setting Preferences</title> +<meta name="AppleTitle" content="Setting Preferences"> +<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>Setting Preferences</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> + +<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>Choose if you want to reload the table after adding, editing or removing a row. If you reload it, you will be sure that the entries showed by Sequel Pro correspond to the entries in the MySQL database, but editing tables will become slow with big tables.</li> + <li>Choose if you want Sequel Pro to show an error message if no rows have been affected after adding or editing a row.</li> + <li>Choose if you want to display the values of blob and text fields (especially with big tables this can speed up the interface significantly because Sequel Pro will load only the blob and text fields of the rows you will be editing).</li> + <li>Choose if you want to limit the rows returned by the MySQL server. You can limit the result to a given number of rows to speed up the interface.</li> + <li>Select a value that is displayed and used to enter NULL-values.</li> + <li>Add favorites used to quickly connect to a MySQL database. Drag&drop them to change their order. Double-click to edit a favorite. Passwords are stored in the Keychain.</li> + </ul> + </td> + <td width="350" valign="top" align="center"> + <img src="preferences.jpg" width="350" height="160" border="0"> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/preferences.jpg b/Resources/Help/topics/preferences.jpg Binary files differnew file mode 100644 index 00000000..64ae8e10 --- /dev/null +++ b/Resources/Help/topics/preferences.jpg diff --git a/Resources/Help/topics/query.html b/Resources/Help/topics/query.html new file mode 100755 index 00000000..bb628047 --- /dev/null +++ b/Resources/Help/topics/query.html @@ -0,0 +1,58 @@ +<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>
\ No newline at end of file diff --git a/Resources/Help/topics/reference.html b/Resources/Help/topics/reference.html new file mode 100755 index 00000000..b746bed9 --- /dev/null +++ b/Resources/Help/topics/reference.html @@ -0,0 +1,212 @@ +<html> +<head> +<title>Sequel Pro Help - MySQL SQL Referernce</title> +<meta name="AppleTitle" content="SQL Reference"> +<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>MySQL SQL Reference</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> +<table border="0" width="95%"> + <tr> + <td> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + In the following commands and functions, any italicized text should be replaced by a variable + or name of your choice. Any text within brackets ( [ and ] ) is optional. This is only a short reference + of the SQL commands supported in MySQL. It is NOT the full list and also may not be complete + nor up-to-date. + </font> + </td> + </tr> +</table> + +<br> +<table border="0" cellpadding="5" cellspacing="2" width="100%"> + <tr> + <td width="60%" valign="top"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Commands</b> + <br> + CREATE DATABASE [IF NOT EXISTS] <i>name</i> + <br> + CREATE [UNIQUE|FULLTEXT] INDEX <i>name</i> ON <i>table</i> (<i>column</i>,..) + <br> + CREATE TABLE [IF NOT EXISTS] <i>name</i> + <br> + DELETE FROM <i>table</i> [WHERE <i>clause</i>] [LIMIT <i>n</i>] + <br> + DROP DATABASE [IF EXISTS] <i>name</i> + <br> + DROP TABLE [IF EXISTS] <i>name</i> + <br> + GRANT <i>privilege</i> ON <i>table</i> TO <i>user</i> + <br> + INSERT [INTO] <i>table</i> [ (column, ...) ] VALUES (values, ...) + <br> + LOAD DATA INFILE <i>file</i> INTO TABLE <i>name</i> + <br> + SELECT [DISTINCT|ALL| |] FROM <i>table</i> [WHERE <i>clause</i> ] + <br> + UPDATE <i>table</i> SET <i>column=value,...</i> [WHERE <i>clause</i>] [LIMIT <i>n</i>] + <br> + <br> + <b>Logical Operators</b> + <br> + NOT <i>or</i> ! - performs a logical not + <br> + OR <i>or</i> | | - performs a logical or + <br> + XOR - performs a logical exclusive or + <br> + AND <i>or</i> && - performs a logical and + </font> + </td> + <td width="40%" valign="top"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Aggregate Functions</b> + <br> + AVG(<i>expression</i>) + <br> + BIT_AND(<i>expression</i>) + <br> + BIT_OR(<i>expression</i>) + <br> + COUNT(<i>expression</i>) + <br> + MAX(<i>expression</i>) + <br> + MIN(<i>expression</i>) + <br> + STD(<i>expression</i>)/STDDEV(<i>expression</i>) + <br> + SUM(<i>expression</i>) + <br> + <br> + <b>General Functions</b> + <br> + ABS(<i>number</i>) + <br> + ACOS(<i>number</i>) + <br> + ADDDATE(<i>date</i>, INTERVAL, <i>amount</i>, <i>type</i>) + <br> + ASCII(<i>char</i>) + <br> + ASIN(<i>number</i>) + <br> + ATAN(<i>number</i>) + <br> + ATAN2(x, y) + <br> + BENCHMARK(<i>num</i>, <i>function</i>) + <br> + BIN((<i>decimal</i>) + <br> + BIT_COUNT(<i>number</i>) + <br> + BIT_LENGTH(<i>number</i>) + <br> + CEILING(<i>number</i>) + <br> + CHAR_LENGTH(<i>string</i>) + <br> + COS(<i>radians</i>) + <br> + COT(<i>radians</i>) + <br> + CURDATE() + <br> + CURTIME() + <br> + DATABASE() + <br> + DATE_FORMAT(<i>date</i>, <i>format</i>) + <br> + DAYNAME(<i>date</i>) + <br> + DAYOFMONTH(<i>date</i>) + <br> + DAYOFWEEK(<i>date</i>) + <br> + DAYOFYEAR(<i>date</i>) + <br> + EXP(<i>power</i>) + <br> + FLOOR(<i>number</i>) + <br> + FORMAT(<i>number</i>, <i>decimals</i>) + <br> + HOUR(<i>time</i>) + <br> + LENGTH(<i>string</i>) + <br> + LOG(<i>number</i>) + <br> + LOWER(<i>number</i>) + <br> + MD5(<i>string</i>) + <br> + MINUTE(<i>time</i>) + <br> + MONTH(<i>date</i>) + <br> + MONTHNAME(<i>date</i>) + <br> + NOW() + <br> + PASSWORD(<i>string</i>) + <br> + QUARTER(<i>date</i>) + <br> + REVERSE(<i>string</i>) + <br> + SECOND(<i>time</i>) + <br> + SIGN(<i>number</i>) + <br> + SPACE(<i>number</i>) + <br> + SQRT(<i>number</i>) + <br> + UPPER(<i>string</i>) + <br> + VERSION() + <br> + WEEK(<i>date</i>) + <br> + WEEKDAY(<i>date</i>) + <br> + YEAR(<i>date</i>) + </font> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/sample_query.html b/Resources/Help/topics/sample_query.html new file mode 100755 index 00000000..66b249fd --- /dev/null +++ b/Resources/Help/topics/sample_query.html @@ -0,0 +1,81 @@ +<html> +<head> +<title>Sequel Pro Help - SQL Query Examples</title> +<meta name="AppleTitle" content="SQL Query Examples"> +<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>SQL Query Examples</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> +<table border="0" width="95%"> + <tr> + <td> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + The following queries are only examples and any use of these queries in a company or critical environment + signifies the prior knowledge and acceptance, on behalf of the implentor, that the authors of this software are not liable for damages or losses in use of these queries. + No guarantees are made as to the quality or reliabity of the queries listed below. They are listed to help database designers/creators in their + work by showing an example. + </font> + </td> + </tr> +</table> +<br> +<br> +<table border="0" cellpadding="5" cellspacing="10" width="100%" align="center"> + <tr> + <td valign="top" bgcolor="#EAEAEA"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Example SELECT Query</b> + <hr> + This obtains information an account table and only returns the accounts with logins of 1 or more, + ordered alphabetically by the person's name. + <br> + <br> + <b>SELECT * FROM accounts WHERE LoginCount > 1 ORDER BY Name</b> + <br> + </font> + </td> + </tr> + <tr> + <td valign="top" bgcolor="#EAEAEA"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Example DELETE Query</b> + <hr> + This query deletes one row of data from a product table. + <br> + <br> + <b>DELETE FROM products WHERE ProductID=5 LIMIT 1</b> + <br> + </font> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/sample_tables.html b/Resources/Help/topics/sample_tables.html new file mode 100755 index 00000000..ba61c094 --- /dev/null +++ b/Resources/Help/topics/sample_tables.html @@ -0,0 +1,374 @@ +<html> +<head> +<title>Sequel Pro Help - SQL Table Examples</title> +<meta name="AppleTitle" content="SQL Table Examples"> +<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>SQL Table Examples</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> +<table border="0" width="95%"> + <tr> + <td> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + The following tables are only examples and any use of these tables in a company or critical environment + signifies the prior knowledge and acceptance, on behalf of the implentor, that the authors of this software are not liable for damages or losses in use of these tables. + No guarantees are made as to the quality or reliabity of the table designs listed below. They are listed to help database designers/creators in their + work by showing an example. + <br> + The schema used is non-standard. It shows the table name above three columns. The first is the name of the variable, the second + is the type of that variable, and the third is the size (if necessary). + </font> + </td> + </tr> +</table> +<br> +<br> +<table border="0" cellpadding="5" cellspacing="10" width="100%" align="center"> + <tr> + <td width="50%" valign="top" bgcolor="#EAEAEA"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Example Accounts Database Table</b> + <hr> + This table was designed for a custom system needing user accounts where they + could have a login and password to a website. It tracks logins, modifications to + the data and who created the account. It also allows the account to be locked out. + The password should be MD5 encrypted and stored in the database that way. + <br> + <br> + <center> + <table width="80%" bgcolor="black" cellspacing="2" border="1" align="center"> + <tr> + <td bgcolor="white" align="center" colspan="3"><font size="-1"> + tblAccounts + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + AccountID + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + INTEGER + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 11 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Name + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 200 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Login + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 12 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Password + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 32 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Locked + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + TINYINT + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + LoginCount + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + INTEGER + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 11 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + LastLogin + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + DATETIME + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Created + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + DATETIME + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + CreatedBy + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 200 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Updated + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + DATETIME + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + UpdatedBy + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 200 + </font></td> + </tr> + </table> + </center> + <br> + * The AccountID is a PRIMARY KEY (also UNIQUE) + <br> + * The Password is MD5 encrypted, hence the length of 32 + <br> + * The Locked value is either zero (0) or one (1) + </font> + </td> + <td width="50%" valign="top" bgcolor="#EAEAEA"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Example Products Database Table</b> + <hr> + This table was designed to store basic production information, possibly in a + small business database or online shopping cart. It is highly recommended + that this table be customized to your needs. + <br> + <br> + <center> + <table width="80%" bgcolor="black" cellspacing="2" border="1" align="center"> + <tr> + <td bgcolor="white" align="center" colspan="3"><font size="-1"> + tblProducts + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + ProductID + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + INTEGER + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 11 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Name + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 200 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + ShortDescription + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 250 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + LongDescription + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + TEXT + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Price + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + DECIMAL(9,2) + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + ImageURL + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 250 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Locked + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + TINYINT + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + ViewCount + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + INTEGER + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 11 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + LastViewed + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + DATETIME + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Created + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + DATETIME + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + CreatedBy + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 200 + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + Updated + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + DATETIME + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + </font></td> + </tr> + <tr> + <td width="50%" bgcolor="white"><font size="-1"> + UpdatedBy + </font></td> + <td width="35%" bgcolor="white" align="center"><font size="-1"> + VARCHAR + </font></td> + <td width="15%" bgcolor="white" align="center"><font size="-1"> + 200 + </font></td> + </tr> + </table> + </center> + <br> + * The ProductID is a PRIMARY KEY (also UNIQUE) + <br> + * The ImageURL points to an image of the product + <br> + * The Locked value is either zero (0) or one (1) + </font> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/sequel-pro_logo.jpg b/Resources/Help/topics/sequel-pro_logo.jpg Binary files differnew file mode 100644 index 00000000..18d9f2da --- /dev/null +++ b/Resources/Help/topics/sequel-pro_logo.jpg diff --git a/Resources/Help/topics/syntax.html b/Resources/Help/topics/syntax.html new file mode 100755 index 00000000..39c4da72 --- /dev/null +++ b/Resources/Help/topics/syntax.html @@ -0,0 +1,49 @@ +<html> +<head> +<title>Sequel Pro Help - Table Syntax Generation</title> +<meta name="AppleTitle" content="Table Syntax Generation"> +<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>Table Syntax Generation</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> + + If you would like to generate a SQL output of your table's syntax (column types, sizes, keys, table name, etc..) use +the "Create Table Syntax" icon at the top of the application in the Sequel Pro Toolbar area. You can then use that text to +create a copy of the table in another database or it may also serve as a backup of the table's schema. If the "Create Table Syntax" icon is +not located in your toolbar then right-click +in the toolbar area and select "Customize Toolbar..." from the menu. You should then see a window +of icons which you can add to your Sequel Pro toolbar including the one mentioned above. +<br> +<br> + +</table> + +</font> + +</body> +</html>
\ No newline at end of file diff --git a/Resources/Help/topics/tables.html b/Resources/Help/topics/tables.html new file mode 100755 index 00000000..3840bb26 --- /dev/null +++ b/Resources/Help/topics/tables.html @@ -0,0 +1,89 @@ +<html> +<head> +<title>Sequel Pro Help - Managing Tables</title> +<meta name="AppleTitle" content="Managing Tables"> +<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>Managing Tables</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 actions with tables, you must first choose the "Structure" 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 fields with the plus-button and drop them with the minus-button.</li> + <li>Edit fields by double-click on the value you want to change. To cancel editing hit the esc-key.</li> + <li><font color="red">Changes aren't written to the database until you deselect the row!</font></li> + <li>You can also drag & drop fields to change their order (if they are not indexed).</li> + </ul> + </td> + </tr> +</table> + +<br> +<br> +<b>Adding, editing, removing and copying tables</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 tables with the plus- and minus-buttons.</li> + <li>If you add a table, Sequel Pro creates a field called "id" because a table must have at least one column. You can change or delete this field afterwards.</li> + <li>Change the name of a table by double-clicking on it. Hit the esc-key to cancel editing.</li> + <li>Select a table and hit the copy button under the list of tables to copy it. If you mark "Copy table content", the new table will also contain all entries of the old table.</li> + </ul> + </td> + </tr> +</table> + +<br> +<br> +<b>Adding and editing indexes</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 indexes with the plus-button and drop them with the minus-button.</li> + <li>Select "Key Type", "Key Name" and "Indexed Columns" in the sheet. If you don't specify a key name, the column name is used as name.</li> + <li>If you want to make an index of more than one column, enter them in the appropriated field separated by commas (without whitespace after the comma!).</li> + </ul> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file |
