SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table employees( emp_id int(10) not null, first_name varchar(20), last_name varchar (20) not null, dept_id int, salary int (10) not null, primary key (emp_id) ); insert into employees ( emp_id, first_name, last_name, salary, dept_id ) values (101, 'Mahesh', 'More', 10000, 10); insert into employees ( emp_id, first_name, last_name, salary, dept_id ) values (102, 'Shubh', 'Khare', 20000, 12); insert into employees ( emp_id, first_name, last_name, salary, dept_id ) values (103, 'Rahul', 'Patil', 30000, 15); insert into employees ( emp_id, first_name, last_name, salary, dept_id ) values (104, 'Ramesh', 'Bore', 40000, 20); insert into employees ( emp_id, first_name, last_name, salary, dept_id ) values (105, 'Shubham', 'Wagh', 50000, 22); create table department( dept_id int, dept varchar(20), dept_loc varchar(20) ); insert into department (dept_id, dept, dept_loc) values (1, 'Chemisty', 'America'); insert into department (dept_id, dept, dept_loc) values (2, 'Physics', 'Dubai'); insert into department (dept_id, dept, dept_loc) values (3, 'Mathematics', 'India'); insert into department (dept_id, dept, dept_loc) values (4, 'Biology', 'England');
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear