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
Subject
Written By
Posted
Executing sql script with out mysql prompt
December 01, 2005 05:20AM
December 01, 2005 08:23AM
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.