On Mon, 03 Mar 2008 14:20:58 -0500, Martin Gainty wrote: > http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html According to > MYSQL doc: > A schema is a database
That contradicts the following claim (to my reading): "A true fully (database, schema, and table) qualified query is exemplified as such: select * from database.schema.table" http://en.wikipedia.org/wiki/ Comparison_of_relational_database_management_systems#Databases_vs_Schemas_.28terminology.29 What' I'm familiar with is: SELECT * FROM database.table; That's ok, that makes sense, this is how MySQL does it and is how I've been doing it. Some databases do it differently, apparently. Apparently MySQL lacks this feature, but what feature is it lacking? There's no equivalent to: SELECT * FROM database.schema.table; thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]