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'); drop database employees;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear