Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
March 24, 2006, 5:37 pm
rate this thread
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
5112 time (different values for each entry, though).
It seemed fine but everytime i try to add more than 249 rows I get an
INSERT INTO INVENTORY
'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?
Re: PHPmyadmin problems after line 249..not syntax
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.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum