diff options
| author | stuconnolly <stuart02@gmail.com> | 2008-12-10 16:52:52 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2008-12-10 16:52:52 +0000 |
| commit | fab9a6506cd04ec8f840c98772a80c44a79c74a7 (patch) | |
| tree | 3cd483487bef381c934717f10df71d306c7eaf97 /Interfaces/English.lproj/english_help/topics/sample_query.html | |
| parent | 4c3b208fad0572d8d1a79bba1bd1b8147fd0f8a6 (diff) | |
| download | sequelpro-fab9a6506cd04ec8f840c98772a80c44a79c74a7.tar.gz sequelpro-fab9a6506cd04ec8f840c98772a80c44a79c74a7.tar.bz2 sequelpro-fab9a6506cd04ec8f840c98772a80c44a79c74a7.zip | |
MERGED r262:266 from branches/stuart02 to trunk to include new project structure.
Diffstat (limited to 'Interfaces/English.lproj/english_help/topics/sample_query.html')
| -rwxr-xr-x | Interfaces/English.lproj/english_help/topics/sample_query.html | 81 |
1 files changed, 81 insertions, 0 deletions
diff --git a/Interfaces/English.lproj/english_help/topics/sample_query.html b/Interfaces/English.lproj/english_help/topics/sample_query.html new file mode 100755 index 00000000..66b249fd --- /dev/null +++ b/Interfaces/English.lproj/english_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 |