Lejban

CREATE TABLE `books` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,  `user_id` int(11) NOT NULL DEFAULT '0',  `name` varchar(160) NOT NULL DEFAULT '',  `author` varchar(160) NOT NULL DEFAULT '',  `publisher` varchar(160) NOT NULL DEFAULT '',  `description` text NOT NULL,  `isbn` varchar(100) NOT NULL DEFAULT '',  PRIMARY KEY  (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;# OkINSERT INTO `books` ( `id` , `created_at` , `user_id` , `name` , `author` , `publisher` , `description` , `isbn` )VALUES (NULL , CURRENT_TIMESTAMP , '0', 'testcase', 'testauthor', 'testpublisher', '', '1234');# OkSELECT *FROM `books`WHERE 1 # Ok, worksUPDATE `books` SET `id` = '1',`created_at` = '2006-12-07 16:00:41',`user_id` = '0',`name` = 'testcase',`author` = 'testauthor',`publisher` = 'testpulbisher',`description` = '',`isbn` = '1234' WHERE `id` = '1'# Works, but creates a new rowUPDATE `books` SET `id` = '1',`created_at` = '2006-12-07 16:00:41',`user_id` = '0',`name` = 'testcase',`author` = 'testauthor',`publisher` = 'testpulbisher',`description` = '',`isbn` = '1234' WHERE `id` = 1# Works