Noobie INSERT syntax error

[Floodster]

Hi Guys,
I've been spending the weekend converting my site from .ASP & Access to .ASP & MySql. I have used the MySql Migration kit for my database & tables but I'm having a few problems.

I have a table which consists of ID, surname & forename. The ID was an autonumber in access & the other 2 columns were text.
I have just tried a simple INSERT query using MySql & I'm getting an error of "Field ID doesn't have a default value"
My syntax was;

INSERT into tbl_members (forename, surname) VALUE ('any', 'body');

can anybody help??

 

[Floodster]

I have fixed this by using changing the column to use 'AUTO_INCREMENT'. Why would the migration tool not have done this for me??