无法删除数据库行，因为它具有外键

-- MySQL 示例
SET FOREIGN_KEY_CHECKS=0;
DELETE FROM your_table WHERE id = your_id;
SET FOREIGN_KEY_CHECKS=1;

-- MySQL 示例
ALTER TABLE child_table
ADD CONSTRAINT fk_name
FOREIGN KEY (column_name)
REFERENCES parent_table(column_name)
ON DELETE CASCADE;

-- MySQL 示例
DELETE FROM child_table WHERE parent_id = your_id;
DELETE FROM parent_table WHERE id = your_id;

-- 创建主表
CREATE TABLE parent_table (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

-- 创建从表，并添加外键约束
CREATE TABLE child_table (
    id INT PRIMARY KEY,
    parent_id INT,
    name VARCHAR(255),
    FOREIGN KEY (parent_id) REFERENCES parent_table(id) ON DELETE CASCADE
);

-- 插入数据
INSERT INTO parent_table (id, name) VALUES (1, 'Parent 1');
INSERT INTO child_table (id, parent_id, name) VALUES (1, 1, 'Child 1');

-- 删除主表中的行，从表中的相关行也会被删除
DELETE FROM parent_table WHERE id = 1;