Normal insert, hard to read:
INSERT INTO table1 ( field1, field2, field3, ... ) VALUES ('value1', 'value2', 'value3', ... );
vs
Easier to read:
INSERT INTO table1 SET field1='value1', field2='value2', field3='value3', ...
Normal insert, hard to read:
INSERT INTO table1 ( field1, field2, field3, ... ) VALUES ('value1', 'value2', 'value3', ... );
vs
Easier to read:
INSERT INTO table1 SET field1='value1', field2='value2', field3='value3', ...