Hi Brent, ahh of course :) thank you so much for answering though.
Alex On 20/01/2008, Brent Baisley <[EMAIL PROTECTED]> wrote: > When you establish a connection, it's a connection to a server, not a > specific DB. You can set a default db so that you don't always have > to specify the db name you are working with. So to answer your > question, no, a new connection is not established. > > Brent > > > On Jan 19, 2008, at 10:19 AM, Alex K wrote: > > > Hi Guys, > > > > What does the statement "select * from otherdb.table" do if I haven't > > explicitly connected to otherdb previously? I would assume it connects > > to otherdb and does the select on table but does it create a new > > connection each time? Is it as efficient as explicitly connecting to > > otherdb and then querying. I'm using webware DBUtils for connection > > pooling. Would these connections also be taken into account? > > > > Thank you so much, > > > > Alex > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql? > > [EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
