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;
# Ok

INSERT INTO `books` ( `id` , `created_at` , `user_id` , `name` , `author` , `publisher` , `description` , `isbn` )
VALUES (
# WorksNULL ,
CURRENT_TIMESTAMP , '0', 'testcase', 'testauthor', 'testpublisher', '', '1234'
);
# Ok

SELECT *
FROM `books`
WHERE 1 
# Ok, works

UPDATE `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 row

UPDATE `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