Building Insert Query
Hi,
Was wondering if someone could help..
I'm transferring data from one database server to another database locally..
I've created a c# windows application to retrieve the data via a dataset which works great..
Was transferring the from the dataset to the local server, started doing this using a MySqlCommand with parameters for each of the fields. This was working, but very slowly..... As it was executing an SQL query for each record.
Then noticed that you could insert several records using:
insert into {tablename} (fields)
values
(field values),
(field values)
So decided to build up the SQL command myself. Now have a small problem with string fields that have speech marks in them!! Anyone got any ideas?
Thanks
Wayne
Subject
Written By
Posted
Building Insert Query
May 19, 2005 07:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.