S

@Sqlda

Self join

MySQL
1 year ago
CREATE TABLE employee( id INT PRIMARY KEY, name VARCHAR(50), manager_id INT ); INSERT INTO employee(id, name, manager_id) VALUES (101, "adam", 103), (102, "bob", 104),

Alter

MySQL
1 year ago
CREATE TABLE student( id INT PRIMARY KEY, name VARCHAR(50), grade VARCHAR(50), marks INT ); INSERT INTO student VALUES (101, "adam", "A", 94),

cascading

MySQL
1 year ago
CREATE TABLE dept( id INT PRIMARY KEY, name VARCHAR(50) ); INSERT INTO dept VALUES (101, "eng"), (102, "maths");