Hi All
In a shell script I have a sentence as given below:
`cat database.update | $MYSQL $DBASE $SQLOPTIONS`;
Here 'database.update' us just a text file which contains MYSQL queries
(say 10 queries). Suppose one of the queries (say query no 5) gives
error on executing in MYSQL prompt and rest of the queries are OK.
When I executed this script, I found queries 1-4 got executed
successfully and queries 6-10 did not get executed at all, since query 5
gave error. However, if I execute the same file (database.update) from
command line (MYSQL prompt) using command 'source database.update', all
the queries are getting executed, though query 5 gives error.
Is there any way in shell script, to execute the file fully through my
script, without exiting on error?
Thanks in advance
Regards
Ajay
--
______________________________________________________________________
Pune GNU/Linux Users Group Mailing List: ([email protected])
List Information: http://plug.org.in/mailing-list/listinfo/plug-mail
Send 'help' to [EMAIL PROTECTED] for mailing instructions.
