Changeset View
Changeset View
Standalone View
Standalone View
autotests/html/test.sql.html
1 | <!DOCTYPE html> | 1 | <!DOCTYPE html> | ||
---|---|---|---|---|---|
2 | <html><head> | 2 | <html><head> | ||
3 | <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> | 3 | <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> | ||
4 | <title>test.sql</title> | 4 | <title>test.sql</title> | ||
5 | <meta name="generator" content="KF5::SyntaxHighlighting (SQL)"/> | 5 | <meta name="generator" content="KF5::SyntaxHighlighting (SQL)"/> | ||
6 | </head><body style="color:#1f1c1b"><pre> | 6 | </head><body style="color:#1f1c1b"><pre> | ||
7 | <span style="color:#898887;">-- comment</span> | 7 | <span style="color:#898887;">-- comment</span> | ||
8 | 8 | | |||
9 | <span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> stuff <span style="font-weight:bold;">COLUMNS</span>(col1 <span style="color:#0057ae;">INT</span>, col2 <span style="color:#0057ae;">Varchar</span>); | 9 | <span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> stuff <span style="font-weight:bold;">COLUMNS</span>(col1 <span style="color:#0057ae;">INT</span>, col2 <span style="color:#0057ae;">Varchar</span>); | ||
10 | <span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> stuff <span style="font-weight:bold;">WHERE</span> <span style="font-weight:bold;">id</span> = <span style="color:#bf0303;">'string'</span>; | 10 | <span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> stuff <span style="font-weight:bold;">WHERE</span> <span style="font-weight:bold;">id</span> = <span style="color:#bf0303;">'string'</span>; | ||
11 | <span style="font-weight:bold;">select</span> * <span style="font-weight:bold;">from</span> stuff <span style="font-weight:bold;">where</span> <span style="font-weight:bold;">id</span> < <span style="color:#b08000;">0.42</span>; | 11 | <span style="font-weight:bold;">select</span> * <span style="font-weight:bold;">from</span> stuff <span style="font-weight:bold;">where</span> <span style="font-weight:bold;">id</span> < <span style="color:#b08000;">0.42</span>; | ||
12 | <span style="font-weight:bold;">Select</span> col1, col2 <span style="font-weight:bold;">From</span> stuff <span style="font-weight:bold;">Where</span> stuff.col1 <span style="font-weight:bold;">IS</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NuLL</span>; | 12 | <span style="font-weight:bold;">Select</span> col1, col2 <span style="font-weight:bold;">From</span> stuff <span style="font-weight:bold;">Where</span> stuff.col1 <span style="font-weight:bold;">IS</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NuLL</span>; | ||
13 | | ||||
14 | <span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> Persons ( | ||||
15 | <span style="font-weight:bold;">ID</span> <span style="color:#0057ae;">int</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span> AUTO_INCREMENT, | ||||
16 | LastName <span style="color:#0057ae;">varchar</span>(<span style="color:#b08000;">255</span>) <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span>, | ||||
17 | FirstName <span style="color:#0057ae;">varchar</span>(<span style="color:#b08000;">255</span>), | ||||
18 | Age <span style="color:#0057ae;">int</span>, | ||||
19 | <span style="font-weight:bold;">PRIMARY</span> <span style="font-weight:bold;">KEY</span> (<span style="font-weight:bold;">ID</span>) | ||||
20 | <span style="font-weight:bold;">CONSTRAINT</span> CHK_Person <span style="font-weight:bold;">CHECK</span> (Age>=<span style="color:#b08000;">18</span> <span style="font-weight:bold;">AND</span> City=<span style="color:#bf0303;">'Sandnes'</span>) | ||||
21 | ); | ||||
22 | | ||||
23 | <span style="font-weight:bold;">SELECT</span> column_name(s) | ||||
24 | <span style="font-weight:bold;">FROM</span> table1 | ||||
25 | <span style="font-weight:bold;">FULL</span> <span style="font-weight:bold;">OUTER</span> <span style="font-weight:bold;">JOIN</span> table2 <span style="font-weight:bold;">ON</span> table1.column_name = table2.column_name; | ||||
26 | | ||||
27 | <span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> Customers | ||||
28 | <span style="font-weight:bold;">WHERE</span> City <span style="font-weight:bold;">LIKE</span> <span style="color:#bf0303;">'[bsp]%'</span>; | ||||
29 | | ||||
30 | <span style="font-weight:bold;">SELECT</span> <span style="color:#644a9b;">Count</span>(*) <span style="font-weight:bold;">AS</span> DistinctCountries | ||||
31 | <span style="font-weight:bold;">FROM</span> (<span style="font-weight:bold;">SELECT</span> <span style="font-weight:bold;">DISTINCT</span> Country <span style="font-weight:bold;">FROM</span> Customers) | ||||
32 | <span style="font-weight:bold;">GROUP</span> <span style="font-weight:bold;">BY</span> Country | ||||
33 | <span style="font-weight:bold;">HAVING</span> <span style="color:#644a9b;">COUNT</span>(CustomerID) > <span style="color:#b08000;">5</span> | ||||
34 | <span style="font-weight:bold;">ORDER</span> <span style="font-weight:bold;">BY</span> <span style="color:#644a9b;">COUNT</span>(CustomerID) <span style="font-weight:bold;">DESC</span>; | ||||
35 | | ||||
36 | <span style="font-weight:bold;">SELECT</span> <span style="color:#bf0303;">'Customer'</span> <span style="font-weight:bold;">As</span> <span style="font-weight:bold;">Type</span>, ContactName, City, Country | ||||
37 | <span style="font-weight:bold;">FROM</span> Customers | ||||
38 | <span style="font-weight:bold;">UNION</span> | ||||
39 | <span style="font-weight:bold;">SELECT</span> <span style="color:#bf0303;">'Supplier'</span>, ContactName, City, Country | ||||
40 | <span style="font-weight:bold;">FROM</span> Suppliers; | ||||
41 | | ||||
42 | <span style="font-weight:bold;">SELECT</span> <span style="color:#644a9b;">COUNT</span>(ProductID), <span style="color:#644a9b;">AVG</span>(Price) | ||||
43 | <span style="font-weight:bold;">FROM</span> Products; | ||||
44 | | ||||
45 | <span style="font-weight:bold;">SET</span> lock_timeout = <span style="color:#b08000;">0</span>; | ||||
46 | <span style="font-weight:bold;">SET</span> client_encoding = <span style="color:#bf0303;">'UTF8'</span>; | ||||
47 | <span style="font-weight:bold;">SET</span> standard_conforming_strings = <span style="font-weight:bold;">on</span>; | ||||
48 | <span style="font-weight:bold;">SET</span> check_function_bodies = <span style="font-weight:bold;">false</span>; | ||||
49 | <span style="font-weight:bold;">SET</span> client_min_messages = warning; | ||||
50 | <span style="font-weight:bold;">SET</span> default_tablespace = <span style="color:#bf0303;">''</span>; | ||||
51 | | ||||
52 | <span style="font-weight:bold;">DROP</span> <span style="font-weight:bold;">TABLE</span> <span style="font-weight:bold;">IF</span> <span style="font-weight:bold;">EXISTS</span> employees; | ||||
53 | | ||||
54 | <span style="font-weight:bold;">ALTER</span> <span style="font-weight:bold;">TABLE</span> <span style="font-weight:bold;">ONLY</span> employees | ||||
55 | <span style="font-weight:bold;">ADD</span> <span style="font-weight:bold;">CONSTRAINT</span> fk_employees_employees <span style="font-weight:bold;">FOREIGN</span> <span style="font-weight:bold;">KEY</span> (reportsto) <span style="font-weight:bold;">REFERENCES</span> employees; | ||||
56 | | ||||
57 | <span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">VIEW</span> [<span style="font-weight:bold;">Current</span> Product <span style="font-weight:bold;">List</span>] <span style="font-weight:bold;">AS</span> | ||||
58 | <span style="font-weight:bold;">SELECT</span> ProductID, ProductName | ||||
59 | <span style="font-weight:bold;">FROM</span> Products | ||||
60 | <span style="font-weight:bold;">WHERE</span> Discontinued = <span style="font-weight:bold;">No</span>; | ||||
61 | | ||||
62 | <span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> [<span style="font-weight:bold;">Current</span> Product <span style="font-weight:bold;">List</span>]; | ||||
63 | | ||||
64 | <span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> [<span style="font-weight:bold;">Category</span> Sales <span style="font-weight:bold;">For</span> <span style="color:#b08000;">1997</span>] | ||||
65 | <span style="font-weight:bold;">WHERE</span> CategoryName = <span style="color:#bf0303;">'Beverages'</span>; | ||||
66 | | ||||
67 | <span style="font-weight:bold;">begin</span> | ||||
68 | <span style="font-weight:bold;">end</span> | ||||
69 | <span style="color:#924c9d;">/</span> | ||||
70 | / | ||||
71 | / u | ||||
13 | </pre></body></html> | 72 | </pre></body></html> |