List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:May 16 2011 2:59pm
Subject:Re: [setting value when INSERT for auto increment]
View as plain text  
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!!

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
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