List:General Discussion« Previous MessageNext Message »
From:Basil Daoust Date:May 16 2011 8:10pm
Subject:Re: [setting value when INSERT for auto increment]
View as plain text  
since your listing the columns, you could just leave off `idlog` from 
the named columns and thus not also need to include the null in the 
inserted values.

INSERT INTO `friendlyCMS`.`log`
(`imepriimek`, `clock`, `action`, `onfile`, `filesize`)
VALUES ($_COOKIE['user'], CURRENT_TIMESTAMP, 'saved', $filename, filesize($filename));



On 16/05/2011 9:59 AM, Johan De Meersman wrote:
> If you're asking what I think you're asking, then yes, both NULL and 0 will trigger
> an autoincrement field to put in the next value.
>
> ----- Original Message -----
>> From: "Grega Leskovšek"<legrega@stripped>
>> To: mysql@stripped
>> Sent: Monday, 16 May, 2011 4:49:43 PM
>> Subject: [setting value when INSERT for auto increment]
>>
>> Should it be null?
>> INSERT INTO `friendlyCMS`.`log` (`idlog`, `imepriimek`, `clock`,
>> `action`, `onfile`, `filesize`) VALUES (NULL, $_COOKIE['user'],
>> CURRENT_TIMESTAMP, 'saved',$filename, filesize($filename));
>> idlog is primaryk ey auto inrement not null...
>> When insertin the value what should I pass it? NULL? Thanks in
>> advance!!

Thread
[setting value when INSERT for auto increment]Grega LeskovÅ¡ek16 May
  • Re: [setting value when INSERT for auto increment]Johan De Meersman16 May
    • Re: [setting value when INSERT for auto increment]Basil Daoust16 May