Re: Alter Table Auto_Increment

On 20 September 2010 19:54, Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> wrote:
> On Mon, Sep 20, 2010 at 2:43 PM, A.M. <agentm(at)themactionfaction(dot)com> wrote:
>> DEFAULT
>
> Sorry just to be clear you're saying that I need to enter the command as:
>
> INSERT INTO table_name DEFAULT VALUES (
> 'data',
> 'data',
> 'data',
> 'data',
> '2010-09-20'
> );
>

Well, you can use the DEFAULT value if you wish:

INSERT INTO table_name (
DEFAULT,
'data',
'data',
'data',
'data',
'2010-09-20'
);

Where the keyword DEFAULT appears, it will, as you'd expect, use the
default value for that column.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935