RE: [PBML] The best option for DB SQL insertion...
- mmmm thats not a bad idea... thanks for the tip...
From: Jenda Krynicky [mailto:Jenda@...]
Sent: Monday, 27 January 2003 5:44 AM
Subject: Re: [PBML] The best option for DB SQL insertion...
From: "Franki" <frankieh@...>
> The script will be reading those files, and connecting to a MySQL$ins=$db->prepare(<<'*END*');
> server on another machine and loading the data into it..
> Now I have two options here (both are easy enough to do) one is to use
> DBI to do all the work using do(INSERT... and the other is to use
> system calls to the MSQL client and pass it the SQL data...
> I just not sure what the best most resource efficient method is..
INSERT INTO TableName (
Field1, Field2, Field3, Field4
) VALUES (
?, ?, ?, ?
===== Jenda@... === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery
Unsubscribing info is here:
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/