From 1d0c281511ce7b35c7e06475d7e147db5a656575 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Wed, 23 Sep 2009 13:29:10 +0000 Subject: Rename (currently unused) help folder. --- .../English.lproj/Help/topics/sample_query.html | 81 ++++++++++++++++++++++ 1 file changed, 81 insertions(+) create mode 100755 Interfaces/English.lproj/Help/topics/sample_query.html (limited to 'Interfaces/English.lproj/Help/topics/sample_query.html') diff --git a/Interfaces/English.lproj/Help/topics/sample_query.html b/Interfaces/English.lproj/Help/topics/sample_query.html new file mode 100755 index 00000000..66b249fd --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/sample_query.html @@ -0,0 +1,81 @@ + + +Sequel Pro Help - SQL Query Examples + + + + + + + + +
+ + + + + + + + + +
+ +

SQL Query Examples

+
+ +
+ +
+ + Back to the main menu +
+
+ + + + +
+ + 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. + +
+
+
+ + + + + + + +
+ + Example SELECT Query +
+ This obtains information an account table and only returns the accounts with logins of 1 or more, + ordered alphabetically by the person's name. +
+
+ SELECT * FROM accounts WHERE LoginCount > 1 ORDER BY Name +
+ +
+ + Example DELETE Query +
+ This query deletes one row of data from a product table. +
+
+ DELETE FROM products WHERE ProductID=5 LIMIT 1 +
+ +
+ + + + + \ No newline at end of file -- cgit v1.2.3