mysql常用命令-积累篇

对于Mysql数据库，自己并不是太熟。所以在这里记录下自己学过的关于他的东西吧。
[b]MyISAM InnoDB 区别:[/b]
最主要的区别：MyISAM 不支持事务等高级处理，而InnoDB类型支持。
MyISAM类型的表强调的是性能，其执行数度比InnoDB类型更快，但是不提供事务支持，而InnoDB提供事务支持已经外部键等高级数据库功能

1. show create table student;查看创建student表的语句

mysql> show create table student;
+---------+-------------------------------------------
| Table   | Create Table
+---------+-------------------------------------------
| student | CREATE TABLE `student` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_name` varchar(255) DEFAULT NULL,
  `student_age` int(11) DEFAULT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk |

2 show engines;

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+-
-----------+
| Engine             | Support | Comment                                                        | Transactions | XA   |
Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+-
-----------+
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL |
NULL       |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   |
NO         |
| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   |
NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   |
NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   |
NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   |
NO         |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   |
NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  |
YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   |
NO         |
+--------------------+---------+----------------------------------------------------------------+--------------+------+-