CONNECT

What is the usage of connect keyword? I've tried to google what is the
difference between CONNECT and USE but got no explanation. It seems
everybody use USE, but am not clear why is the CONNECT used?

mysql> CONNECT test1pizza
Connection id: 9
Current database: test1pizza

mysql> use test1pizza
Database changed

Please help me ... Thanks in advance, Grega Leskovšek

♥♥â™=A5 When the sun rises I receive and when it sets I=
forgive! ♥♥â™=A5
˜â™=A5 -> http://moj.skavt.net/gleskovs/ <- â™=A5 Always, Greg=
a Leskovšek

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: CONNECT

On 10/13/2011 14:41, Grega Leskovšek wrote:
> What is the usage of connect keyword? I've tried to google what is the
> difference between CONNECT and USE but got no explanation. It seems
> everybody use USE, but am not clear why is the CONNECT used?
>
> mysql> CONNECT test1pizza
> Connection id: 9
> Current database: test1pizza
>
> mysql> use test1pizza
> Database changed
>
> Please help me ... Thanks in advance, Grega Leskovšek
>
> ♥♥♥ When the sun rises I receive and when it sets I forgive! ♥♥♥
> ˜♥ -> http://moj.skavt.net/gleskovs/<- ♥ Always, Grega Leskovšek
>

That's a client-side command for the mysql command line interface, not a
MySQL-side command. You may have been looking in the wrong place:
quoting http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html
============
connect [db_name host_name]], \r [db_name host_name]]

Reconnect to the server. The optional database name and host name
arguments may be given to specify the default database or the host where
the server is running. If omitted, the current values are used.
============

--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org