![]() |
|
XP is just a number | |
PerlMonks |
Re: Batch Loading of data through DBIby zebedee (Pilgrim) |
on Jan 23, 2005 at 18:36 UTC ( #424421=note: print w/replies, xml ) | Need Help?? |
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
|
|