如何使用InnoDB引擎表创建MySQL表？
要使用InnoDB引擎创建表，我们可以使用ENGINE命令。这是创建表的查询。
mysql> create table EmployeeRecords - > ( - > EmpId int, - > EmpName varchar(100), - > EmpAge int, - > EmpSalary float - > )ENGINE=INNODB;
上面我们已将ENGINE设置为INNODB。
使用DESC命令检查有关表的完整描述。
mysql> DESC EmployeeRecords;
以下是输出。
+-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | EmpId | int(11) | YES | | NULL | | | EmpName | varchar(100) | YES | | NULL | | | EmpAge | int(11) | YES | | NULL | | | EmpSalary | float | YES | | NULL | | +-----------+--------------+------+-----+---------+-------+ 4 rows in set (0.05 sec)
检查表是否用InnoDB创建。
mysql> SHOW TABLE STATUS FROM business LIKE 'EmployeeRecords';
这是输出-
+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | employeerecords | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-10-22 15:22:01 | NULL | NULL | utf8mb4_unicode_ci | NULL | | | +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ 1 row in set (0.10 sec)
在上面的输出中，“Engine”显示为“InnoDB”。
热门推荐
10 圣诞祝福语简短小学
11 祖国七十华诞简短祝福语
12 老师送的祝福语简短
13 生日祝福语大全女生简短
14 祝女性生日祝福语简短
15 牛年女神节祝福语简短
16 情人表白祝福语简短大气
17 老公开业祝福语简短
18 官宣新年祝福语简短