|
|
|
| The stupid question is the question not asked | |
| PerlMonks |
Re: Batch Loading of data through DBIby zebedee (Pilgrim) |
| on Jan 23, 2005 at 13:36 UTC ( [id://424421]=note: print w/replies, xml ) | Need Help?? |
This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.
mysqldump generates the following ...
LOCK TABLES makes WRITE;
INSERT INTO makes VALUES (1,'Acura'),(2,'Alfa Romeo'),(3,'Aston Martin'),(4,'Audi'),...(83,'Lifan');
UNLOCK TABLES;
I do not know if the INSERT INTO syntax is MySQL-specific or not. (The "..." is where I cut out a whole list of items.)
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||