Difference between revisions of "Portable SQL/Statements/Data manipulation"
From Linuxnetworks
(data manipulation statements) |
m |
||
| Line 12: | Line 12: | ||
UPDATE ''table'' | UPDATE ''table'' | ||
SET ''column''=''value'' [,''column''=''value'']* | SET ''column''=''value'' [,''column''=''value'']* | ||
| − | WHERE '' | + | WHERE ''conditions'' |
== DELETE statement == | == DELETE statement == | ||
DELETE FROM ''table'' | DELETE FROM ''table'' | ||
| − | WHERE '' | + | WHERE ''conditions'' |
---- | ---- | ||
Back to [[OpenDBX|Overview]] | Back to [[OpenDBX|Overview]] | ||
Revision as of 19:33, 8 May 2007
The data manipulation statements provided by the database vendors are pretty much standard compliant as long as their base form is used. They can be feed to almost every SQL DBMS without having to worry about portability.
The only thing to care about is the where-clause of the UPDATE and the DELETE statement. Keep sure to avoid anything but simple operators and boolean statements like AND/OR.
INSERT statement
INSERT INTO table ( column [,column]* ) VALUES ( value [,value]* )
UPDATE statement
UPDATE table SET column=value [,column=value]* WHERE conditions
DELETE statement
DELETE FROM table WHERE conditions
Back to Overview
