[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)
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)
+--------------------+
| 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)
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)
+---------------+--------------+---------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-------------------+--------------+------------+----------------+---------------------------------+----------------+
| 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>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-665619/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-665619/