milov.nl

Interaction design • webdevelopment • web art • photography

December 2004

There's an INSERT INTO ... SET ... syntax? I had no idea.

So instead of this...
INSERT INTO sometable
     ( field1, field2, field3 )
VALUES 
     ( 'value1', 'value2', 'value3' )
...it's actually possible to use this:
INSERT INTO sometable
   SET field1 = 'value1',
       field2 = 'value2',
       field3 = 'value3'