CONNECT or USE ?

[Kristian Nilssen]

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.