Hi,
Anyone know how to call other sql scripts from withing SQL using mySQL ?
What I need to do is run a script (first.sql) and from withing this script call another script file (either second.sql or third.sql).
any ideas ?
cheers
You could do it with Stored Procedures, but I don't think they have been implemented in the current release of mysql.
thanks, so its not possible to do this then?
Not yet in mysql. Stored procs might be available in a future release, check at www.mysql.com. Or you could go to a dbms that already supports them.