Hi,

I'm trying to insert 5112 lines of data into a table named INVENTORY
via phpmyadmin. All the data types are CHAR and have a limit of 50
(there are 8 columns). I tried inserting the data by commands;
basically copying and pasting

INSERT INTO INVENTORY VALUES
('AHS','312','cpu','dell','3248','HN97P01','','');

5112 time (different values for each entry, though).

It seemed fine but everytime i try to add more than 249 rows I get an
error:

SQL query:

INSERT INTO INVENTORY
VALUES (
'AHS', '312', 'cpu', 'dell', '3248', 'HN97P01', '', ''
)

MySQL said: Documentation


This only happens when I try to insert more than 249 rows...is there
some sort of limit for one table that i'm not aware of?

Thanks.

<stbrenner@gmail.com> wrote in message
news:1143221832.328225.187990@t31g2000cwb.googlegr oups.com...
> I'm trying to insert 5112 lines of data into a table named INVENTORY
> via phpmyadmin. All the data types are CHAR and have a limit of 50
> (there are 8 columns). I tried inserting the data by commands;
> basically copying and pasting

Egad! That's a lot of work, and there ought to be a better way to do that.
I don't use phpmyadmin a lot, and I don't have it installed right now.
Isn't there a feature to read a file and execute it as a script? (Their
documentation is awful!) I seem to recall a "browse" button for selecting a
script file. Look on the SQL tab.

Regards,
Bill K.