Insert only in specific columns with MySQL

If you have a big MySQL table and you want to insert data only in specific columns, then you can do this with naming the columns in parentheses after the table name:

INSERT INTO `wp_posts`(`post_author`,`post_content`,`post_title`,`post_date`) VALUES (0,'Hello World','Text...',NOW());

This works even without apostrophes:

INSERT INTO wp_posts(post_author,post_content,post_title,post_date) VALUES (0,'Hello World','Text...',NOW());