How do I insert an empty row, but have the autonumber update correctly?

Question

I was hoping to be able to do something like

INSERT INTO `table`;

or maybe even a SET clause like

SET `primary_key` = null

where all the columns of the table aren't set (and are left to their default), with the exception of the autonumbered primary key which should be set.

Any suggestions?

Answer 1

INSERT INTO `table` (`primary_key`) VALUES (NULL);