MySQL Forums
Forum List  »  Newbie

Building Insert Query
Posted by: Wayne Gibson
Date: May 19, 2005 07:37AM

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

Options: ReplyQuote


Subject
Written By
Posted
Building Insert Query
May 19, 2005 07:37AM
May 20, 2005 08:56AM


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.