MySQL Cascade delete

1. Create a primary table first

CREATE TABLE User (

UId INT auto_increment not NULL PRIMARY KEY,

UName VARCHAR (+) not NULL
);

2. Create a sheet from the table and add constraints

CREATE TABLE Score

{

Sid int Auto_increment NOT NULL primary key,

Sore numeric (10,3),

UID int,

FOREIGN KEY (UID) REFERENCES User (UID) on DELETE CASCADE

}

The most important thing in MySQL is: On delete CASCADE It is the key to a cascade, and then delete the primary table when deleting the outer join table automatically deletes the record containing its properties

MySQL Cascade delete