Out of Range Error

thekidscareya

When I run this query on MySQL 5.0 server through PHP 4.3.10, I get an error.

PHP Code:

mysql_query("INSERT INTO `tbl_graphics` VALUES('', '$height', '$width', '$format', '$details');") or die(mysql_error());

MySQL Error:

Out of range value adjusted for column 'id' at row 1

MySQL Table Structure:

CREATE TABLE `tbl_graphics` (
`id` int(11) NOT NULL auto_increment,
`height` int(11) NOT NULL,
`width` int(11) NOT NULL,
`format` text NOT NULL,
`details` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

What am I doing wrong? How do I fix this? Thanks for all your help in advance. I really appreciate it.

Sxooter

For the record, it's sloppy to not identify the columns you are inserting into, because at some future date the table might get recreated with a different order, etc... But, if you're going to do it this way, or if you want to specify the column for some reason, try the DEFAULT keyword in place of ''.

'' really isn't an integer, and it isn't NULL. MySQL's old behaviour of insert a default when you said NULL was just plain broken and against the spec. Expect a lot more headaches like this if you learned SQL using MySQL, as there are tons of little things like this in it. Oh well, at least they're slowly heading towards compliance with the SQL standard, even if it's taken them years to admit that maybe foreign keys and triggers are good things. :eek: