mysql删除主键报错

ALTER TABLE table_name DROP FOREIGN KEY foreign_key_name;

ALTER TABLE table_name DROP INDEX index_name;

-- 删除外键约束
ALTER TABLE users DROP FOREIGN KEY fk_user_profile;

-- 删除主键约束
ALTER TABLE users DROP PRIMARY KEY;

-- 重新创建表
CREATE TABLE new_users (
    id INT AUTO_INCREMENT,
    name VARCHAR(255),
    email VARCHAR(255),
    PRIMARY KEY (id)
);

-- 将数据插入新表
INSERT INTO new_users SELECT * FROM users;

-- 删除旧表
DROP TABLE users;

-- 重命名新表
RENAME TABLE new_users TO users;