MariaDB [zbdba]> show create table zbdba\G
|
*************************** 1. row ***************************
|
Table: zbdba
|
Create Table: CREATE TABLE `zbdba` (
|
`id` int(11) NOT NULL,
|
`name` varchar(20) DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
1 row in set (0.000 sec)
|
|
MariaDB [zbdba]>
|
MariaDB [zbdba]>
|
MariaDB [zbdba]> insert into zbdba() values(1, 'aa');
|
Query OK, 1 row affected (0.001 sec)
|
|
MariaDB [zbdba]> insert into zbdba() values(2, 'bb');
|
Query OK, 1 row affected (0.001 sec)
|
|
MariaDB [zbdba]> insert into zbdba() values(3, 'cc');
|
Query OK, 1 row affected (0.001 sec)
|
|
MariaDB [zbdba]> select * from zbdba;
|
+----+------+
|
| id | name |
|
+----+------+
|
| 1 | aa |
|
| 2 | bb |
|
| 3 | cc |
|
+----+------+
|
3 rows in set (0.001 sec)
|
|
MariaDB [zbdba]>
|
MariaDB [zbdba]>
|
MariaDB [zbdba]> ALTER TABLE zbdba ENGINE = MRG_MYISAM;
|
Query OK, 0 rows affected (0.005 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
MariaDB [zbdba]> select * from zbdba;
|
Empty set (0.000 sec)
|
|
|