http://www.perlmonks.org?node_id=1085553


in reply to Re: Not able to insert data in mysql
in thread Not able to insert data in mysql

Yeah, your suggestion might avoid a problem when the total number of table columns differs from number of values inserted.

But it's not inherently necessary:

http://sqlfiddle.com/#!2/c6d7e/2/0 ( using MySQL 5.5.32, but works unaltered on postgres)

(BTW, what a nice litte tool sqlfiddle is)