Shulou(Shulou.com)06/01 Report--

Validating the MGR schema table requires a primary key, otherwise inserting data will report an error.

Mysql > show tables;+-+ | Tables_in_dd | +-+ | a | +-+ 1 row in set (0.00 sec) mysql > desc a +-+ | Field | Type | Null | Key | Default | Extra | +-+-+ | id | int (11) | YES | | NULL | | +-+-+ 1 row in set (0.00 sec) mysql > insert into a values (1) ERROR 3098 (HY000): The table does not comply with the requirements by an external plugin.mysql > alter table an add primary key (id); Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0mysql > desc a +-+ | Field | Type | Null | Key | Default | Extra | +-+-+ | id | int (11) | NO | PRI | NULL | | +-+-+ 1 row in set (0.01sec) mysql > insert into a values (1) Query OK, 1 row affected (0. 00 sec) mysql > insert into a values (1); Query OK, 1 row affected (0. 00 sec) mysql > select * from a Tantra Kui Kui + | id | +-- + | 1 | +-+ 1 row in set (0. 00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.