测试表
mysql> show create table keys_order\G
*************************** 1. row ***************************
Table: keys_order
Create Table: CREATE TABLE `keys_order` (
`id` int(11) NOT NULL,
`name` varchar(10) NOT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
注意这里特意设置了主键是由
id
和name
组成。
测试数据
mysql> use xiaohaizi;
mysql> select * from keys_order;
+----+-------+------+
| id | name | age |
+----+-------+------+
| 7 | seven | 7 |
| 8 | eight | 8 |
| 9 | nine | 9 |
| 10 | ten | 10 |
+----+-------+------+
4 rows in set (0.00 sec)
数据目录查看表对应的独立表空间文件
mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| datadir | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)
cd /var/lib/mysql
cd ‘database_name’;
xxd keys_order.ibd