I've been trying to insert a value into a table with this:
- Code: Select all
INSERT INTO `page` VALUES('2','asdfasdf','0','','2','1','20080320193013','20080320193013')
But I get the following error: Incorrect integer value: '' for column 'parent' at row 1
I figured the timestamps might be messing it up, but I've tried it with one of them and none of them, still doesn't work. Any help? This is the table:
- Code: Select all
DROP TABLE IF EXISTS `divaba_development`.`page`;
CREATE TABLE `divaba_development`.`page` (
`id` smallint(5) unsigned NOT NULL,
`name` varchar(20) default NULL,
`type` tinyint(4) default NULL,
`parent` smallint(5) unsigned default NULL,
`order` smallint(5) unsigned default NULL,
`nav` tinyint(3) unsigned default NULL,
`updated_at` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`created_at` timestamp NOT NULL default '0000-00-00 00:00:00',
UNIQUE KEY `id` (`id`),
KEY `parent` (`parent`),
KEY `order` (`order`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;