SQLize Online / PHPize Online  /  SQLtest Online

create table employee (employee_name varchar(30) NOT NULL PRIMARY KEY, street varchar(30), city varchar(30), id int); insert into employee values ('Sopan','Gujarat','Ahmedabad',NULL), ('Shivangi','Maharashtra','Pune',3), ('Jaskiran','Punjab','Jalandhar',7), ('Shefali','Haryana','Panchkula',NULL), ('Epsa','Rajasthan','Jaipur',5), ('Neha','Manipur','Aizwal',5), ('Mahima','Nagaland','Kohima',5), ('Snigdha','Delhi','New_delhi',5); create table works (company_name varchar(30), salary int, employee_name varchar(30) FOREIGN KEY REFERENCES employee(employee_name)); insert into works values ('ABC',1000,'Sopan'), ('DEF',5000,'Shivangi'), ('GHI',3000,'Jaskiran'), ('JKL',9000,'Shefali'), ('MNO',2000,'Epsa'), ('PQR',7600,'Neha'), ('STU',4500,'Mahima'), ('VWX',2800,'Snigdha'); select * from works;