Differences between version 8 and predecessor to the previous major change of SQL.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 8 | Last edited on Monday, May 15, 2006 7:54:43 pm | by DavidHallett | Revert |
| Older page: | version 7 | Last edited on Monday, May 15, 2006 4:57:03 pm | by AristotlePagaltzis | Revert |
@@ -8,9 +8,9 @@
__Retrieving data:__
<pre>
- SELECT ''cols
'' FROM ''tables
'' WHERE ''condition''
+ SELECT ''t.column_one'', ''t.column_...'', ''n.column_n
'' FROM ''table_one t'', ''table_n n
'' WHERE ''condition''
</pre>
Eg. to find the access level of user number 154:''''
@@ -20,9 +20,9 @@
__Inserting data:__
<pre>
- INSERT INTO ''table'' (''columns
'') VALUES (''values
'')
+ INSERT INTO ''table'' (''column_one'', ''column_...'', ''column_n
'') VALUES (''value_one'', ''value_...'', ''value_n
'')
</pre>
Eg. to add a new user:''''
@@ -34,9 +34,9 @@
__Updating data:__
<pre>
- UPDATE ''table'' SET ''column''=''value'' WHERE ''condition''
+ UPDATE ''table'' SET ''column_one
''=''value_one'', ''column_...''=''value_...'', ''column_n''=''value_n
'' WHERE ''condition''
</pre>
Eg. to set an accesslevel of 15 to everyone whos name starts with a C:''''
