Results 1 to 3 of 3
May 24, 2002, 01:35 #1
- Join Date
- Jul 2001
- 0 Post(s)
- 0 Thread(s)
compatibilty of MySQL's INSERT ... SET syntax?
i was wondering if MySQL's INSERT INTO table SET col1=1, col2=2 ... syntax worked in other databases? it seems more logical (and easier to keep track of) like UPDATE's syntax rather than the ... (col1, col2) VALUES (1, 2) method.
also, while we're on the subject, what about REPLACE INTO ..., does it exist in other databases?- Matt ** Ignore old signature for now... **
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
"Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR