Bank Account`);Error in query (1553): Cannot drop index 'Customer ID': needed in a foreign keyconstraint(当我试图添加新索引时,如何才能让它停止删除该索引呢?)
我的MySQL版本字符串是"5.5.60-MariaD
col2 BIGINT(20) NOT NULL, col4 VARCHAR(100) NOT NULL, KEY(col1, col2, col3));CREATE TABLE IF NOT EXISTS testTable col3 BIGINT(20) NOT NULL,
col4 VARCHAR(100)
我正在尝试删除当前索引,但仍然收到错误MySQL Cannot drop index needed in a foreign key constraintID TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY,UNIQUE(TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY,