Bug #64559 Add support of ANSI SQL syntax : INSERT INTO <table name> DEFAULT VALUES
Submitted: 6 Mar 2012 7:32 Modified: 6 Mar 2012 14:40
Reporter: [ name withheld ] Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[6 Mar 2012 7:32] [ name withheld ]
As described by SQL1992 and supported by most of RDBMS :

<insert statement> ::=
   INSERT INTO <table name>
               <insert columns and source>

<insert columns and source> ::= [ <left paren> <insert column list> <right paren> ]
      <query expression>

An <insert columns and source> that specifies DEFAULT VALUES is equivalent to an <insert columns and source> that specifies a <query expression> of the form


where the number of "DEFAULT" entries is equal to the number of columns of T.

How to repeat:
This is FR so no repeat
[6 Mar 2012 14:40] Valeriy Kravchuk
Thank you for the feature request.