Thanks alot for your help. I set the auto increment as suggested and it worked. Regards Toni On Sun, Nov 13, 2011 at 10:43 PM, drive view <driveview@xxxxxxxxx> wrote: > Hi, > > I'm a novice to MySQL and am currently facing the following difficulty. > I'm trying to update a table with a row of data the primary key of which is > an ID which I believe is an auto incrementing serial number. My first > question is how to check if this is the case. > > Secondly while trying to insert such a row leaving out this column mySql > is inserting the row at ID 0 (the previous ID's in the table are from 1 to > 9), but then will not take further inserts. > > Thanks for any help available. > > > Regards > > Toni