You can do it a couple of ways:
1)
mysql -u<your user name> -p<yourpassword> Databasename <
scriptfile.sql
2)
From the mysql prompt:
Mysql> \. Scriptfile.sql
-----Original Message-----
From: Kurt [mailto:k.killen@stripped]
Sent: Wednesday, May 07, 2003 12:51 PM
To: mysql@stripped
Subject: making a mysql script
Shoot me now. In Oracle you can write an SQL procedure, in notepad for
example, to create a table. You can then save this file in case you need
to recreate the table later. The problem I am having is the naming of
the file format and what command to use to run the file from the MySQL
command prompt.
In Oracle you type
SQL> @filename.sql
What do I name the file?
How to I run the file?
Thanks
Kurt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
