On Thu, Jun 05, 2003 at 10:32:58PM +0200, Bart Lateur wrote: > FWIW, MySQL allows the syntax > > SELECT * FROM database.table > > where "table" is the name of a table in the database with name > "database". I'm not sure how standard that is :)
Much more standard is: SELECT * FROM schema.table MySQL doesn't have schemas, though, and their internal hierarchy makes that a reasonable substitute. -johnnnnnnnn
