CONNECT or USE ?
We have a shell script where the mysql query occasionally hangs. I notice that the query uses CONNECT instead of the more usual USE. Can't actually find any info on the CONNECT command but it seems to work.
e.g.
TITLE=`mysql -u$DBUSER -p$DBPWD -h$DBSERVER -N -e "connect orinfo;select title from task where taskid='${TASKID}';"`
what to use, CONNECT or USE in this case?
Also, the taskid column is an integer. Could where taskid='${TASKID}' be confusing mysql because I have single quotes indicating a string?
thanks,
Kristian.
Subject
Written By
Posted
CONNECT or USE ?
September 09, 2004 01:46AM
September 09, 2004 03:00AM
September 09, 2004 03:00AM
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.