RE: Execute multiple scripts

2001-07-13 Thread Don Read
On 13-Jul-01 Järkeborn Joacim wrote: > Hi, > > I have approx. 110 SQL scripts in a directory. Each containing DROP TABLE, > CREATE TABLE, lots of INSERT INTO and finally a COMMIT. > I need to run all these script in mysql console. > > My plan is to write a perl script that looks into the direct

RE: Execute multiple scripts

2001-07-12 Thread Jorge del Conde
Hi, The purpose of the execute parameter I to execute a command and then quit; An example of how to use the "--execute" or "-e" parameter follows: Prompt> mysql -e "select * from user" mysql [prints everything from mysql.user to stdout] If you want to execute the contents of a file through the