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.