Hi,
Type all of the create statement in a text file (i.e. sql_file) and then
just call mysql [database] < sql_file from the prompt.
As for the editor, you can use any common text file editor available
(xemacs, vi, pico, nano).
Regards,
Jorge
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <jorge@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mexico City, Mexico
<___/
----- Original Message -----
From: "Vasu Thirumalai" <vthirum@stripped>
To: <mysql@stripped>
Sent: Wednesday, March 21, 2001 10:48 PM
Subject: How to create a script file?
Hi!!
I want to have a sql script to create the tables. i.e. have all the lines
that I will type at the sql prompt in a script file called create_tables or
something and execute that file to create the tables !!
How to do ?Is there an editor for mysql where I can type out these lines.
Please help me.
Thank you
Harini
