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 <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mexico City, Mexico
<___/
----- Original Message -----
From: "Vasu Thirumalai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php