* D Bamud
> I have sql commands written in a file. How to run this file at sql> prompt
> so that commands executed thru this batch file. Something similar
> to Oracles
> sql> @/mydir/mysql.sql
mysql> source "myfile.sql"
or
mysql> \. "myfile.sql"
--
Roger
-
In the script file add the first statement as 'use db_name;'
Mysql/bin>mysql < file_name.sql
Thanks,
Rama Raju
-Original Message-
From: D Bamud [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 4:01 PM
To: [EMAIL PROTECTED]
Subject: How to run commands written i
I have sql commands written in a file. How to run this file at sql> prompt
so that commands executed thru this batch file. Something similar to Oracles
sql> @/mydir/mysql.sql
-
Before posting, please check:
http://www.mysql.