Re: Efficiency of NULLIFie expression

2011-05-16 Thread Hal�sz S�ndor
2011/05/14 21:47 +0200, misiaq You're right about explain. That is why I suggested to use explain EXTENDED and then SHOW WARNINGS. Second query will show you the optimizer output. As far as I understand - that was the par of your question. Yes, I did that. That output showed no

Re: [setting value when INSERT for auto increment]

2011-05-16 Thread Basil Daoust
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'

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 > Subject: [setting value when INSERT fo

[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