The error 1264 Out of range value adjusted for column mostly occurs when INSERT query makes try to insert an empty value into a NOT NULL field. So 'id' is a NOT NULL field in your table against which you are inserting empty ('') value. Means, you must pass some value instead of empty value against NOT NULL type field. Further, because your id field is also AUTO_INCREMENT so you can change your query by passing NULL value against the id field. Change your query from:

INSERT INTO tbl_oer values('', '18', '', 'testsaleem', 'test',
                           '', '', '', '', '', 
                           'saleem@website-developer-service.com',
                           '', '', '', '', '', '', '');

to

INSERT INTO tbl_oer values(NULL, '18', '', 'testsaleem', 'test',
                           '', '', '', '', '', 
                           'saleem@website-developer-service.com', 
                           '', '', '', '', '', '', '');

Posted in: MySQL

Related FAQ's

Marius Ion ANGEL HOT SOFT LLC (800) 316-7677