Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table employee2170 (emp_id varchar(10) primary key,city varchar(15) not null,salary varchar(10),age varchar(10),email_id varchar(35),check(age>17),designation varchar(10) default (AP));
- insert into employee2170 (emp_id,city,salary,age,email_id)values(11412170,'goraya',100000,19,'tajinder.jhally@gmail.com');
- insert into employee2170 (emp_id,city,salary,age,email_id)values(11412171,'jalandhar',10000,21,'taj.jhally@gmail.com');
- insert into employee2170 (emp_id,city,salary,age,email_id)values(11412173,'chandighard',200000,19,'jinder.jhally@gmail.com');
- insert into employee2170 (emp_id,city,salary,age,email_id)values(11412174,'delhi',500000,19,'lalit.jhally@gmail.com');
- alter table employee2170 add name varchar(15)
- select * from employee2170
- update employee2170 set name ='tajinder' where emp_id = 11412170;
- update employee2170 set name ='taj' where emp_id = 11412171;
- update employee2170 set name ='jinder' where emp_id = 11412173;
- update employee2170 set name ='lalit' where emp_id = 11412174;
- update employee2170 set name ='revo' where emp_id = 11412172;
- ------------------------------------------------------------------------------------------------------
- create table customer2170 (c_id varchar(10) primary key,name varchar(10),city varchar(10));
- insert into customer2170 (c_id,name,city)values(11412170,'tajinder','goraya');
- insert into customer2170 (c_id,name,city)values(11412171,'taj','jalandhar');
- insert into customer2170 (c_id,name,city)values(11412172,'jinder','chaard');
- insert into customer2170 (c_id,name,city)values(11412173,'lalit','delhi');
- -----------------
- create table order2170 (o_id varchar(10) primary key,o_no varchar(20),c_id varchar(10),foreign key(c_id) references customer2170 (c_id));
- insert into order2170 values(1412170,'a0',11412170);
- insert into order2170 values(1412171,'a2',11412171);
- insert into order2170 values(1412172,'a3',11412173);
- insert into order2170 values(1412173,'a4',11412170);
- =--------------------
- alter table order2170 drop primary key;
- alter table order2170 add primary key (o_id);
- alter table order2170 add constraint c_id primary key(c_id);
- alter table order2170 drop constraint ... ;
- ---
- select age from table_name between 20 and 30;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement