mysql修改被外键约束的列

SET FOREIGN_KEY_CHECKS=0;

-- 修改列
ALTER TABLE your_table MODIFY your_column new_data_type;

SET FOREIGN_KEY_CHECKS=1;

-- 删除外键约束
ALTER TABLE your_table DROP FOREIGN KEY your_foreign_key;

-- 修改列
ALTER TABLE your_table MODIFY your_column new_data_type;

-- 重新创建外键约束
ALTER TABLE your_table ADD CONSTRAINT your_foreign_key FOREIGN KEY (your_column) REFERENCES referenced_table(referenced_column);

-- 修改主键
ALTER TABLE referenced_table MODIFY primary_key_column new_data_type;

-- 确保所有引用该主键的外键都能正确更新或删除

CREATE TABLE customers (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE orders (
    id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE,
    FOREIGN KEY (customer_id) REFERENCES customers(id)
);