List:MySQL on Win32« Previous MessageNext Message »
From:PF: MySQL Date:August 2 2004 2:21pm
Subject:RE: [win32] USE statement in procedure
View as plain text  
> 
> Thanks, Shawn, I'll try the USE batabasename.tablename in a stored
> procedure and see if that works.  

He wasn't saying to use the "USE" statement at all.

He was suggesting you use the full database name (database.table) in
your statements.

SELECT field1,field2 FROM database.tablename

-Kevin
Thread
[win32] USE statement in procedurerdo mail list address31 Jul
  • Re: [win32] USE statement in procedurerdo mail list address31 Jul
  • Re: [win32] USE statement in procedureSGreen2 Aug
  • Re: [win32] USE statement in procedurerdo mail list address2 Aug
    • Re: [win32] USE statement in procedureSGreen2 Aug
    • Re: [win32] USE statement in procedurerdo mail list address2 Aug
RE: [win32] USE statement in procedurePF: MySQL2 Aug
  • RE: [win32] USE statement in procedurerdo mail list address2 Aug