MySQL Forums
Forum List  »  MySQL Query Browser

Running dynamically created SQL script
Posted by: Tom Ward
Date: March 22, 2006 10:22AM

I want to create a dynamic update script based on the results of a query. How can I execute the script from a script tab in QB?

For example, I can create an update script like this:
select 'update table1 set col1=''' column2, ''';' from table3
into outfile 'c:/tempsql.sql'

Then, how can I call the sql file created in the same script?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Running dynamically created SQL script
March 22, 2006 10:22AM


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.