When inserting into regular database systems, like Oracle, DB2, and even PostgreSQL, the omitted attributes from an INSERT are automatically set to default. Not so with MyISAM tables on MySQL. The syntax required by MySQL for an implicit default when multiple attributes are inserted is DEFAULT. For example:
INSERT INTO my_table VALUES (?,?,DEFAULT,?,DEFAULT)
will set the third and fifth parameters to default values.
Note that this has been only tested with the JDBC driver, and other database drivers might behave differently.
References:
