Problems? Is your data what you think it is? | |
PerlMonks |
Re: Batch Loading of data through DBIby zebedee (Pilgrim) |
on Jan 23, 2005 at 18:36 UTC ( [id://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
|
|