MySQL Forums
Forum List  »  Stored Procedures

How to prepare a bulk insert statements and execute them in a single query
Posted by: Samir Dash
Date: July 21, 2012 04:49AM

Hello,

I have a stored procedure where I have created a query with Insert into....select * from table name.

But this is creating problem in my replication server and it is always running behind. So I want to separate insert and select query.

Select query will be taken in a cursor and now please suggest how we will prepare the insert statements into one query and executre it.

Regards,
Samira Kumar Dash

Options: ReplyQuote




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.