Re: insert...select only inserts first record [SOLVED]

Hi I got a reply offlist from Shawn Green telling me to check my indexes on table pending_cart. As it turned out, the primary index (id) did not have its auto_increment bit set. ALTER TABLE `pending_cart` CHANGE `id` `id` INT( 11 ) DEFAULT '0' NOT NULL

Re: insert...select only inserts first record

Andy Pieters <[EMAIL PROTECTED]> wrote on 05/11/2005 04:41:05 PM: > Hi all > > I want to 'copy' the contents of the table 'cart', where userid=... to the > table pending_cart. > > Here is some example data for the table 'cart' > ++++-+ > | id | userid | prodid | qty | >

insert...select only inserts first record

Hi all I want to 'copy' the contents of the table 'cart', where userid=... to the table pending_cart. Here is some example data for the table 'cart' ++++-+ | id | userid | prodid | qty | ++++-+ | 25 |123 | 15 | 1 | | 23 |124 | 14