rhel mysql5.5_rhel4 mysql 5.5_查看业务数据库的表名及表列_管理

[root@localhost /]# mysql -h192.168.2.213 -uyisile -pdfyd8088

mysql: Unknown OS character set 'GB18030'.

mysql: Switching to the default character set 'latin1'.

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2440

Server version: 5.5.0-m2-community-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| cms_hzdfyd         |

| mysql              |

| test               |

| yisile             |

| yisile_db          |

| yisile_sns         |

| yisilecms          |

+--------------------+

8 rows in set (0.00 sec)

mysql> use information_schema;  #这东东相当于oracle system表空间, 里面一堆表,用于内部管理,相当于oracle的数据字典

Database changed

mysql> show tables;

+---------------------------------------+

| Tables_in_information_schema          |

+---------------------------------------+

| CHARACTER_SETS                        |

| COLLATIONS                            |

| COLLATION_CHARACTER_SET_APPLICABILITY |

| COLUMNS                               |

| COLUMN_PRIVILEGES                     |

| ENGINES                               |

| EVENTS                                |

| FILES                                 |

| GLOBAL_STATUS                         |

| GLOBAL_VARIABLES                      |

| KEY_COLUMN_USAGE                      |

| PARTITIONS                            |

| PLUGINS                               |

| PROCESSLIST                           |

| PROFILING                             |

| REFERENTIAL_CONSTRAINTS               |

| ROUTINES                              |

| SCHEMATA                              |

| SCHEMA_PRIVILEGES                     |

| SESSION_STATUS                        |

| SESSION_VARIABLES                     |

| STATISTICS                            |

| TABLES                                |

| TABLE_CONSTRAINTS                     |

| TABLE_PRIVILEGES                      |

| TRIGGERS                              |

| USER_PRIVILEGES                       |

| VIEWS                                 |

| INNODB_CMP_RESET                      |

| INNODB_TRX                            |

| INNODB_CMPMEM_RESET                   |

| INNODB_LOCK_WAITS                     |

| INNODB_CMPMEM                         |

| INNODB_CMP                            |

| INNODB_LOCKS                          |

+---------------------------------------+

35 rows in set (0.00 sec)

mysql> select * from columns where table_schema='yisile' and table_name='yisile_notice';#查看yisile数据库yisile_notice表的所有列相关信息

+---------------+--------------+---------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-------------------+--------------+------------+----------------+---------------------------------+----------------+

| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME    | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | CHARACTER_SET_NAME | COLLATION_NAME    | COLUMN_TYPE  | COLUMN_KEY | EXTRA          | PRIVILEGES                      | COLUMN_COMMENT |

+---------------+--------------+---------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-------------------+--------------+------------+----------------+---------------------------------+----------------+

| def           | yisile       | yisile_notice | ID          |                1 | NULL           | NO          | bigint    |                     NULL |                   NULL |                19 |             0 | NULL               | NULL              | bigint(20)   | PRI        | auto_increment | select,insert,update,references |                |

| def           | yisile       | yisile_notice | TITLE       |                2 | NULL           | NO          | varchar   |                       50 |                    100 |              NULL |          NULL | gb2312             | gb2312_chinese_ci | varchar(50)  |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | CONTENT     |                3 | NULL           | YES         | varchar   |                      255 |                    510 |              NULL |          NULL | gb2312             | gb2312_chinese_ci | varchar(255) |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | POINT_COUNT |                4 | NULL           | YES         | int       |                     NULL |                   NULL |                10 |             0 | NULL               | NULL              | int(11)      |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | createTime  |                5 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL | NULL               | NULL              | datetime     |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | CREATOR     |                6 | NULL           | YES         | varchar   |                       50 |                    100 |              NULL |          NULL | gb2312             | gb2312_chinese_ci | varchar(50)  |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | MODIFIER    |                7 | NULL           | YES         | varchar   |                       50 |                    100 |              NULL |          NULL | gb2312             | gb2312_chinese_ci | varchar(50)  |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | MODIFY_TIME |                8 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL | NULL               | NULL              | datetime     |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | ROLE_ID     |                9 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 | NULL               | NULL              | bigint(20)   |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | USER_ID     |               10 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 | NULL               | NULL              | bigint(20)   |            |                | select,insert,update,references |                |

| def           | yisile       | yisile_notice | TYPE_ID     |               11 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 | NULL               | NULL              | bigint(20)   | MUL        |                | select,insert,update,references |                |

+---------------+--------------+---------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-------------------+--------------+------------+----------------+---------------------------------+----------------+

11 rows in set (0.00 sec)

mysql>