Re: AUTO_INCREMENT Problem.

[Phillip Ward]

So, to clarify, you changed this:

insert into my_table (MY_NAMES) values ('Barry', 'Elliott', 'Robin', 'Bob', 'Steven');

which was trying to push a list of five values into a single field ("MY_NAMES") in a single row, into this:

insert into my_table ( MY_NAMES ) 
values 
  ( 'Barry' )
, ( 'Elliott' )
, ( 'Robin' )
, ( 'Bob' )
, ( 'Steven' );

which inserts a single value into each of five separate rows.

Brackets matter.

Regards, Phill W.