aboutsummaryrefslogtreecommitdiffstats
path: root/Resources/Help/topics/sample_query.html
diff options
context:
space:
mode:
Diffstat (limited to 'Resources/Help/topics/sample_query.html')
-rwxr-xr-xResources/Help/topics/sample_query.html81
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">
+&nbsp;<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