MySQL Forums
Forum List  »  Newbie

Executing sql script with out mysql prompt
Posted by: sreejith s
Date: December 01, 2005 05:20AM

Hi All,
I'm a newbie into Mysql arena.
How can i run an sql script in mysql without (or before) the mysql> prompt appears?.
In a broad sense, for example we have sevaral options for mysql like mysql -u -p and all.
I would like to know whether there is any option commands (like -u) to execute a script say abc.sql.
I'm expecting a method like what in Oracle!

{ sqlplus -s $ OraString << ! filename.sql ;
commit;
exit;
! }

HOw ever this command is not working with MySql.

Please help me if some one know this issue or faced it before.

Sree

Options: ReplyQuote


Subject
Written By
Posted
Executing sql script with out mysql prompt
December 01, 2005 05:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.