Portable SQL/Statements/Data manipulation - Revision history

Nose: removed backlink

2008-06-22T13:06:55Z

removed backlink

Nose: Portable SQL - Data manipulation statements moved to Portable SQL/Statements/Data manipulation

2007-05-17T14:27:43Z

Portable SQL - Data manipulation statements moved to Portable SQL/Statements/Data manipulation

Nose at 17:33, 8 May 2007

2007-05-08T17:33:59Z

Nose: data manipulation statements

2007-05-07T20:52:21Z

data manipulation statements

New page

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 ''where-clause''

== DELETE statement ==

DELETE FROM ''table''
WHERE ''where-clause''

----
Back to [[OpenDBX|Overview]]

← Older revision		Revision as of 13:06, 22 June 2008
Line 18:		Line 18:
	DELETE FROM ''table''		DELETE FROM ''table''
	WHERE ''conditions''		WHERE ''conditions''
−
−
−	~~----~~
−	~~Back to [[OpenDBX\|Overview]]~~

← Older revision	Revision as of 14:27, 17 May 2007
(No difference)

@@ Line 12: / Line 12: @@
   UPDATE ''table''
   SET ''column''=''value'' [,''column''=''value'']*
-  WHERE ''where-clause''
+  WHERE ''conditions''
 == DELETE statement ==
   DELETE FROM ''table''
-  WHERE ''where-clause''
+  WHERE ''conditions''
 ----
 Back to [[OpenDBX|Overview]]