Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

Links

XODOX
Impressum

#1: CONNECT

Posted on 2011-10-13 20:41:01 by legrega

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

Report this message

#2: Re: CONNECT

Posted on 2011-10-13 21:07:55 by shawn.l.green

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

Report this message