saikatd, MySQL - rextester

saikatd

Create table product (product_id varchar(10) primary key, product_name varchar(20), manufacturer_name
char(20),product_rate double(9,4), sell_price double(9,4),product_description varchar(25));
Create table client (client_id varchar(10) primary key, client_name char(20),address varchar(15), city
char(15),pin double(8), state char(15),bal_due double(9,4));
Create table salesman (salesman_id varchar(10) primary key, salesman_name char(20),address varchar(15), city
char(15),pin double(8), state char(15),salary double(9,4));
Create table sales_order_details (sales_order_no varchar(10) primary key, sales_order_date date, client_id
varchar(10) references client(client_id), salesman_id varchar(10) references salesman(salesman_id) ,
bill_payby_party char(5), delivery_date date,product_rate double(9,4), tot_quantity_order
double(8),cancel_date date default NULL);
Insert into product values("p001","lux_soap","Lux_international",15.67,20.43,"soap");
Insert into product values("p002","copy","times_copy_org",14.80,16.40,"copy");
Insert into product values("p003","marry_biscuit","marigold_org",2218.80,2220.40,"buiskit");
Insert into product values("p004",'mitsubisi_pen','pen_international',2015.67,2120.43,'pen');
Insert into product values('p005','learn_books','book_world',5104.80,5116.40,'book');
Insert into product values("p006","tata_steel","tata_org",5118.80,5120.40,"tata");
Insert into product values("p007","seagate hdd","seaget_world",5104.80,5116.40,"HDD1034");
Insert into product values("p008","dvd writer","frontec_org",5118.80,5120.40,"DVDRW");
Insert into client values("cn01001","alak roy"," b.d.para","amarpur",799101,"tripura",390.9);
Insert into client values("cn01002","suman roy"," puk para","agartala",799102,"tripura",2390.9);
Insert into client values("cn01004","priya das"," chora para","kamalpur",799301,"tripura",1390.9);
Insert into client values("cn01005","mita mia"," kamal para","singur",799721,"tripura",190.9);
Insert into client values("cn01006","pulak roy"," bircity","sonitpur",799141,"assam",110.9);
Insert into client values("cn01007","munni das"," nappam","sonitpur",799152,"assam",190.9);
Insert into client values("cn01008","kusum roy"," city_dos","tezpur",799141,"assam",110.9);
Insert into client values("cn01009","mina das"," pachmile","tezpur",799152,"assam",190.9);
Insert into client values("cn01003","moytree nayak"," pachmile","tezpur",799152,"assam",9990.9);
Insert into client values("cn01010","pauri mia"," pachmile","tezpur",799152,"assam",2990.9);
Insert into client values("cn01011","manali das"," satmile","tezpur",799154,"assam",3990.9);
Insert into salesman values("s001","Rohan das","nappam","Tezpur",79970,"Assam",8000);
Insert into salesman values("s002","Rohan das","nappam","Tezpur",799170,"Assam",8000);
Insert into salesman values("s003","Smita das","nirjuli","itanagar",799701,"Arunachal",9000);
Insert into salesman values("s004","Kabir bora","nappam","Tezpur",799703,"Assam",8500);
Insert into salesman values("s005","Neha singh","borbota","sonitpur",795970,"assam",9600);
Insert into salesman values("s006","Priya agarwal","gandhi road ","32 distric",799750,"delhi",9900);
Insert into salesman values("s007","Ashok Paul","filmcity","munnabari",799740,"mumbai",8900);
Insert into sales_order_details values("on01001","01-aug-2008","cn01001","s001","yes","20-aug-2008",
2220.40,50,'');
Insert into sales_order_details values("on01002","12-aug-2008","cn01004","s001", "yes","23-aug-2008",
2220.40,15,"");
Insert into sales_order_details values("on01003","12-aug-2008","cn01005","s003", "yes","26-aug-2008",
2220.40,10,"");
Insert into sales_order_details values("on01004","13-aug-2008","cn01004","s001", "yes","20-aug-2008",
2220.40,15,"");
Insert into sales_order_details values("on01005","14-aug-2008","cn01002","s002", "no","30-aug-2008",
2220.40,52, "28-march-2008");
Insert into sales_order_details values("on01006","15-aug-2008","cn01001","s001", "yes","31-aug-2008",
2220.40,53,"");
Insert into sales_order_details values("on01007","16-jan-2008","cn01003","s004", "yes","28-aug-2008",
2220.40,54,"");
Insert into sales_order_details values("on01008","01-feb-2008","cn01004","s003", "no","28-aug-2008",
8220.40,54, "18-march-2008");
Select * from client;
Select * from product;
Select * from salesman;
Select * from sales_order_details;


run \| edit \| history \| help	0