in UNIX derivatives,
vi a text file, and write your create/other sql into it then save and close
it.
cat your_file | ./bin/mysql -uyour_username -p your_database
you will be prompted to enter a password for your username.
then enter your password.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 6:34 PM
Subject: how to make SQL command by a file?
>
> It is easy make an error while writing SQL coimmand to create table,
> etc...
> So I'd like to write this command (CREATE TABLE....) in a file then run
> this
> command in mysql:
> How can I do?
> how can I write it?
> Thank you in advance.
> Mario.
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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