sree.., MySQL - rextester

sree..

Create table saikat11 (product_id varchar(10) primary key, product_name varchar(20), manufacturer_name
char(20),product_rate decimal(9,4), sell_price decimal(9,4),product_description varchar(25));
Create table client11 (client_id varchar(10) primary key, client_name char(20),address varchar(15), city
char(15),pin decimal(8), state char(15),bal_due decimal(9,4));
Create table salesman11 (salesman_id varchar(10) primary key, salesman_name char(20),address varchar(15), city
char(15),pin decimal(8), state char(15),salary decimal(9,4));
Create table sales_order_details11 (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 decimal(9,4), tot_quantity_order decimal(8),cancel_date date default NULL);
Insert into saikat11 values('p001','lux_soap','Lux_international','15.67','20.43','soap');
	Insert into saikat11 values('p002','copy','times_copy_org','14.80','16.40','copy');
	Insert into saikat11 values('p003','marry_biscuit','marigold_org','2218.80','2220.40','buiskit');
	Insert into saikat11 values('p004','mitsubisi_pen','pen_international','2015.67','2120.43','pen');
	Insert into saikat11 values('p005','learn_books','book_world','5104.80','5116.40','book');
	Insert into saikat11 values('p006','tata_steel','tata_org','5118.80','5120.40','tata');
	Insert into saikat11 values('p007','seagate hdd','seaget_world','5104.80','5116.40','HDD1034');
	Insert into saikat11 values('p008','dvd writer','frontec_org','5118.80','5120.40','DVDRW');

Insert into client11 values('cn01001','alak roy','b.d.para','amarpur','799101','tripura','390.9');
	Insert into client11 values('cn01002','suman roy','puk para','agartala','799102','tripura','2390.9');
	Insert into client11 values('cn01004','priya das','chora para','kamalpur','799301','tripura','1390.9');
	Insert into client11 values('cn01005','mita mia','kamal para','singur','799721','tripura','190.9');
	Insert into client11 values('cn01006','pulak roy','bircity','sonitpur','799141','assam','110.9');
	Insert into client11 values('cn01007','munni das','nappam','sonitpur','799152','assam','190.9');
	Insert into client11 values('cn01008','kusum roy','city_dos','tezpur','799141','assam','110.9');
	Insert into client11 values('cn01009','mina das','pachmile','tezpur','799152','assam','190.9');
	Insert into client11 values('cn01003','moytree nayak','pachmile','tezpur','799152','assam','9990.9');
	Insert into client11 values('cn01010','pauri mia','pachmile','tezpur','799152','assam','2990.9');
	Insert into client11 values('cn01011','manali das','satmile','tezpur','799154','assam','3990.9');

Insert into salesman11 values('s001','Rohan das','nappam','Tezpur','79970','Assam','8000');
	Insert into salesman11 values('s002','Rohan das','nappam','Tezpur','799170','Assam','8000');
	Insert into salesman11 values('s003','Smita das','nirjuli','itanagar','799701','Arunachal','9000');
	Insert into salesman11 values('s004','Kabir bora','nappam','Tezpur','799703','Assam','8500');
	Insert into salesman11 values('s005','Neha singh','borbota','sonitpur','795970','assam','9600');
	Insert into salesman11 values('s006','Priya agarwal','gandhi road','32 distric','799750','delhi','9900');
	Insert into salesman11 values('s007','Ashok Paul','filmcity','munnabari','799740','mumbai','8900');

Insert into sales_order_details11 values('on01001','01-aug-2008','cn01001','s001','yes','20-aug-2008','2220.40','50','28-march-2008');
	Insert into sales_order_details11 values('on01002','12-aug-2008','cn01004','s001','yes','23-aug-2008','2220.40','15','28-march-2008');
	Insert into sales_order_details11 values('on01003','12-aug-2008','cn01005','s003','yes','26-aug-2008','2220.40','10','28-march-2008');
	Insert into sales_order_details11 values('on01004','13-aug-2008','cn01004','s001','yes','20-aug-2008','2220.40','15','28-march-2008');
	Insert into sales_order_details11 values('on01005','14-aug-2008','cn01002','s002','no','30-aug-2008','2220.40','52','28-march-2008');
	Insert into sales_order_details11 values('on01006','15-aug-2008','cn01001','s001','yes','31-aug-2008','2220.40','53','28-march-2008');
	Insert into sales_order_details11 values('on01007','16-jan-2008','cn01003','s004','yes','28-aug-2008','2220.40','54','28-march-2008');
	Insert into sales_order_details11 values('on01008','01-feb-2008','cn01004','s003','no','28-aug-2008','8220.40','54','18-march-2008');


run \| edit \| history \| help	0