Task-1 solution
-------------------
1.1-> create database AssignDb
-----------------------------------------------------------------------------------
1.2-> create table cust_info(
cust_id int primary key,
cust_name varchar(20),
cust_Address varchar(100),
cust_connect_date varchar(30),
contact_No varchar(15)
);
-----------------------------------------------------------------------------------
--
1.3-> INSERT INTO cust_info VALUES
(101, 'Rajeev Singh', 'Lucknow', '12-dece-2012', 05226565114),
(102, 'Jitendra Verma', 'Sitapur', '01-Jan-2013', 9838505980),
(103, 'Ravi Singh', 'barabanki', '15-Jan-2013', 9936652039),
(104, 'priya Singh', 'Lucknow', '16-Jan-2013', 9936390301),
(105, 'Brijesh Mishra', 'barabanki', '16-feb-2013', 8738970899),
(106, 'Amit Singh', 'Lucknow', ,18-mar-2013', 0548-2202798);
-----------------------------------------------------------------------------------
---
1.4->
i> select * from cust_info
ii> select cust_id,cust_name from cust_info;
iii> select cust_Address from cust_info where cust_Address='lucknow';
iv> select * from cust_info order by cust_name asc;
v> select * from cust_info order by cust_name desc;
-----------------------------------------------------------------------------------
----
1.5=>
i>delete from cust_info where cust_id=105;
ii> update cust_info set contact_No=0522-6767144 where cust_id=106;
iii> truncate table cust_info;
iv> drop table cust_info;