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?