hadn’t filled in some code i was completing and within it was a sql statement of the form:
INSERT INTO TableName () VALUES ();
to my surprise, this is valid syntax, and inserted a row with a correct auto_increment for the primary key, and null or defaults for the remaining columns.

• 0 Comments

when mixing standard selects containing table aliases with LEFT JOIN’s you need be aware of a critical change as of mysql 5… if you reference a table alias in an ON clause the same way you might have in verison 4, mysql may report an ‘unknown column’ error.
so, a query of the form:
SELECT a.id FROM […]

• 12 Comments