diff options
Diffstat (limited to 'Resources/Help/topics/sample_query.html')
| -rwxr-xr-x | Resources/Help/topics/sample_query.html | 81 |
1 files changed, 81 insertions, 0 deletions
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 |