作者：够不李先生 | 来源：互联网 | 2024-10-30 18:52
I have created a table with both a primary key and a unique key, however, the error message ""Curren
I have created a table with both a primary key and a unique key, however, the error message ""Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available." still appears on phpmyadmin.
It is stopping me from inserting data when using INSERT.. ON DUPLICATE KEY into the database table, as it :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| &＃096;CREATE TABLE &＃096;Rest_Details&＃096; (
&＃096;Resturant_ID&＃096; int(34) NOT NULL AUTO_INCREMENT,
&＃096;Resturant_name&＃096; varchar(100) NOT NULL,
&＃096;Resturant_des&＃096; varchar(200) NOT NULL,
&＃096;Res_Address_Line_1&＃096; varchar(200) NOT NULL,
&＃096;Res_Address_Line_2&＃096; varchar(200) DEFAULT NULL,
&＃096;City_name&＃096; varchar(100) NOT NULL,
&＃096;Resturant_Postcode&＃096; varchar(8) DEFAULT NULL,
&＃096;Cat_ID&＃096; tinyint(11) NOT NULL,
&＃096;Avg_Del&＃096; tinyint(11) NOT NULL,
&＃096;Est_Del&＃096; tinyint(11) NOT NULL,
&＃096;Email1&＃096; varchar(200) NOT NULL,
&＃096;Email2&＃096; varchar(200) DEFAULT NULL,
&＃096;Min_ord&＃096; tinyint(11) NOT NULL,
PRIMARY KEY (&＃096;Resturant_ID&＃096;),
UNIQUE KEY &＃096;Resturant_name&＃096; (&＃096;Resturant_name&＃096;)
) ENGINE&＃061;InnoDB AUTO_INCREMENT&＃061;2 DEFAULT CHARSET&＃061;utf8&＃096; |
_OS X Yosemite _:
* MySQL:*
PHP version 5:
phpMyAdmin version: 4.4.10
该提问来源于开源项目：phpmyadmin/phpmyadmin
Okay, I think the remaining issue is #11816
京公网安备 11010802041100号