show create table tablename;--查看某张表用的存储引擎（结果的"ENGINE="部分）
alter table tablename ENGINE=InnoDB--修改引擎
create table tablename(fieldname1 fieldtype1,fieldname2 fieldtype2,..) ENGINE=engine_name;--创建表时设置存储引擎
8、例如：
（1）登录MySQL服务器后，查看当前时间，登录的用户以及数据库的版本
Mysql代码
mysql> select now(),user(),version();
+---------------------+----------------+-----------+
| now() | user() | version() |
+---------------------+----------------+-----------+
| 2012-02-26 20:29:51 | root@localhost | 5.5.20 |
+---------------------+----------------+-----------+
1 row in set (0.00 sec)
（2）显示数据库列表
Mysql代码
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.03 sec)
（3）新增数据库并查看
Mysql代码
mysql> create database test_db;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| test_db |
+--------------------+
5 rows in set (0.00 sec)
（4）选择数据库
Mysql代码
mysql> use test_db;
Database changed
查看已选择的数据库：
Mysql代码
mysql> select database();
+------------+
| database() |
+------------+
| test_db |
+------------+
1 row in set (0.00 sec)
（5）显示当前数据库的所有数据表
Mysql代码
mysql> show tables;
Empty set (0.00 sec)
（6）新建数据表并查看
mysql> create table person(
-> id int,
-> name varchar(20),
-> sex char(1),
-> birth date
-> );
Query OK, 0 rows affected (0.09 sec) Mysql代码
mysql> show tables;
+-------------------+
| Tables_in_test_db |
+-------------------+
| person |
+-------------------+
1 row in set (0.00 sec)
（7）获取表结构
Mysql代码
mysql> desc person;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
或者
Mysql代码
mysql> describe person;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
（8）查询表中的数据
Mysql代码
mysql> select * from person;
Empty set (0.00 sec)
（9）插入数据
Mysql代码
mysql> insert into person(id,name,sex,birth)
-> values(1,'zhangsan','1','1990-01-08');
Query OK, 1 row affected (0.04 sec)
查询表中的数据：
Mysql代码
mysql> select * from person;
+------+----------+------+------------+
| id | name | sex | birth |
+------+----------+------+------------+
| 1 | zhangsan | 1 | 1990-01-08 |
+------+----------+------+------------+
1 row in set (0.00 sec)
（10）修改字段的类型
Mysql代码
mysql> alter table person modify sex char(8);
Query OK, 1 row affected (0.17 sec)
Records: 1 Duplicates: 0 Warnings: 0
查看字段描述：
Mysql代码
mysql> desc person;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| nam