获取数据库和表信息

Posted on 2008-11-18 11:06 strong.xu 阅读(107) 评论(0) 编辑收藏举报

获取数据库和表信息：
mysql> connect;
mysql> show databases;
mysql> show tables;
mysql> show tables from db_name;
mysql> show columns from tbl_name;
mysql> show index from tbl_name;
mysql> show table status;
mysql> show table status from db_name;
mysql> show create database db_name;
mysql> show create table tbl_name;