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, 0 insertions, 81 deletions
diff --git a/Resources/Help/topics/sample_query.html b/Resources/Help/topics/sample_query.html
deleted file mode 100755
index 66b249fd..00000000
--- a/Resources/Help/topics/sample_query.html
+++ /dev/null
@@ -1,81 +0,0 @@
-<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