PHPmyadmin problems after line 249..not syntax

[stbrenner]

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','c pu','dell','324 8','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.

[Bill Karwin]

<st*******@gmai l.com> wrote in message
news:11******** **************@ t31g2000cwb.goo glegroups.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.