Re: MySQL System Tables
Posted by: Trudy Pelzer
Date: July 13, 2005 07:50AM

Joseph,

SELECT * FROM INFORMATION_SCHEMA.TABLES will
return metadata information on every table, while
SELECT * FROM INFORMATION_SCHEMA.COLUMNS will
return metadata information on every column.

You need MySQL 5.0 to use the INFORMATION_SCHEMA.

Trudy Pelzer, Engineering Project Manager
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Options: ReplyQuote


Subject
Views
Written By
Posted
14768
October 06, 2004 03:13AM
8083
October 06, 2004 11:03AM
6156
June 26, 2005 10:28PM
Re: MySQL System Tables
49178
July 13, 2005 07:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.