I will try to use this archive to use with other database related example:
CREATE TABLE Employee(
id int,
first_name VARCHAR(15),
last_name VARCHAR(15),
start_date DATE,
end_date DATE,
salary FLOAT(8,2),
city VARCHAR(10),
description VARCHAR(15)
);
insert into Employee(id,first_name, last_name, start_date, end_Date,
salary, City, Description)
values (1,'Jack', 'Schrvaski', '19990720', '20110721',
1224.56, 'Toronto', 'Programmer');
insert into Employee(id,first_name, last_name, start_date, end_Date,
salary, City, Description)
values (1,'David', 'Moron', '19990720', '20110721',
1224.56, 'Toronto', 'Designer');
insert into Employee(id,first_name, last_name, start_date, end_Date,
salary, City, Description)
values (1,'Eric', 'Ron', '19980829', '20110321',
1114.56, 'Toronto', 'Tester');
insert into Employee(id,first_name, last_name, start_date, end_Date,
salary, City, Description)
values (1,'Frost', 'Robert', '19990110', '20110710',
1224.56, 'Toronto', 'Manager');
Post a Comment