mysql 如何看一个表的索引 我现在的工具有时候展现实在太慢所以我不得不开始用命令 比如1 看一个表所有索引2 看1个表的dll语句 或者建立表语句 , 也就是字段详细信息3 看的触发器 外键 等 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SHOW INDEX FROM tbl_nameSHOW CREATE TABLE tbl_name 1 看一个表所有索引show index from tableName;2 看1个表的dll语句 或者建立表语句 , 也就是字段详细信息show create table tablename3 看的触发器 外键 等 SHOW TRIGGERS like 'xxxx'; 终于选用命令行工具了 个人觉得,学习数据库就应该用命令行才能学到东西。mysql> show index from t1;+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+| t1 | 0 | PRIMARY | 1 | id | A | NULL | NULL | NULL | | BTREE | |+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+1 row in set (0.00 sec)mysql>mysql> show create table t1;+-------+-----------------------------------------------------------------------| Table | Create Table+-------+-----------------------------------------------------------------------| t1 | CREATE TABLE `t1` ( `id` int(11) NOT NULL, `col` int(11) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 |+-------+-----------------------------------------------------------------------1 row in set (0.00 sec)mysql> desc t1;+-------+---------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-------+---------+------+-----+---------+-------+| id | int(11) | NO | PRI | NULL | || col | int(11) | YES | | NULL | |+-------+---------+------+-----+---------+-------+2 rows in set (0.00 sec)mysql> show columns from t1;+-------+---------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-------+---------+------+-----+---------+-------+| id | int(11) | NO | PRI | NULL | || col | int(11) | YES | | NULL | |+-------+---------+------+-----+---------+-------+2 rows in set (0.00 sec)mysql> show full columns from t1;+-------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |+-------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+| id | int(11) | NULL | NO | PRI | NULL | | select,insert,update,references | || col | int(11) | NULL | YES | | NULL | | select,insert,update,references | |+-------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+2 rows in set (0.00 sec)mysql>mysql> show triggers like 'test1';+---------+--------+-------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |+---------+--------+-------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+| testref | INSERT | test1 | BEGIN INSERT INTO test2 SET a2 = NEW.a1; DELETE FROM test3 WHERE a3 = NEW.a1; UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1; END | BEFORE | NULL | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci |+---------+--------+-------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+1 row in set (0.00 sec) mysql 问题,超急!救我!!!! 用Mysql查询出A表中与掉B表相同的部分,并输出结果 mysql cluster管理节点启动 自编辑中值函数median,mysql中报错Can't open shared library 急!触发器"stack depth limit exceeded"错误是咋回事啊? 【超低级请教】Mysql 链接问题 mysql 数据库的查询问题 mysql数据库建表时用到condition关键字,应该如何引用? how to "update some record from select"? mysql 搜索问题 搞不明白的查询! 不能建表 怎么回事
SHOW CREATE TABLE tbl_name
show index from tableName;2 看1个表的dll语句 或者建立表语句 , 也就是字段详细信息
show create table tablename3 看的触发器 外键 等
SHOW TRIGGERS like 'xxxx';
mysql> show index from t1;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| t1 | 0 | PRIMARY | 1 | id | A | NULL | NULL | NULL | | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.00 sec)mysql>
mysql> show create table t1;
+-------+-----------------------------------------------------------------------
| Table | Create Table
+-------+-----------------------------------------------------------------------
| t1 | CREATE TABLE `t1` (
`id` int(11) NOT NULL,
`col` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------------
1 row in set (0.00 sec)mysql> desc t1;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| col | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)mysql> show columns from t1;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| col | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)mysql> show full columns from t1;
+-------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+-------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
| id | int(11) | NULL | NO | PRI | NULL | | select,insert,update,references | |
| col | int(11) | NULL | YES | | NULL | | select,insert,update,references | |
+-------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
2 rows in set (0.00 sec)mysql>mysql> show triggers like 'test1';
+---------+--------+-------+----------------------------------------------------
--------------------------------------------------------------------------------
---------------+--------+---------+---------------------------------------------
-------------------+----------------+----------------------+--------------------
--+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode
| Definer | character_set_client | collation_connectio
n | Database Collation |
+---------+--------+-------+----------------------------------------------------
--------------------------------------------------------------------------------
---------------+--------+---------+---------------------------------------------
-------------------+----------------+----------------------+--------------------
--+--------------------+
| testref | INSERT | test1 | BEGIN
INSERT INTO test2 SET a2 = NEW.a1;
DELETE FROM test3 WHERE a3 = NEW.a1;
UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
END | BEFORE | NULL | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUB
STITUTION | root@localhost | latin1 | latin1_swedish_ci | latin
1_swedish_ci |
+---------+--------+-------+----------------------------------------------------
--------------------------------------------------------------------------------
---------------+--------+---------+---------------------------------------------
-------------------+----------------+----------------------+--------------------
--+--------------------+
1 row in set (0.00 sec)