Thanks alot for your help.  I set the auto increment as suggested and it



On Sun, Nov 13, 2011 at 10:43 PM, drive view <> 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

Reply via email to