Re: [setting value when INSERT for auto increment]

2011-05-16 Thread Basil Daoust
m: "Grega Leskovšek" To: mysql@lists.mysql.com 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'

Re: [setting value when INSERT for auto increment]

2011-05-16 Thread Johan De Meersman
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" > To: mysql@lists.mysql.com > Sent: Monday, 16 May, 2011 4:49:43 PM > Sub

[setting value when INSERT for auto increment]

2011-05-16 Thread Grega Leskovšek
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 i