Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sree..
Create table saikat6 (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 client6 (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 salesman6 (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_details6 (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 saikat6 values('p001','lux_soap','Lux_international','15.67','20.43','soap'); Insert into saikat6 values('p002','copy','times_copy_org','14.80','16.40','copy'); Insert into saikat6 values('p003','marry_biscuit','marigold_org','2218.80','2220.40','buiskit'); Insert into saikat6 values('p004','mitsubisi_pen','pen_international','2015.67','2120.43','pen'); Insert into saikat6 values('p005','learn_books','book_world','5104.80','5116.40','book'); Insert into saikat6 values('p006','tata_steel','tata_org','5118.80','5120.40','tata'); Insert into saikat6 values('p007','seagate hdd','seaget_world','5104.80','5116.40','HDD1034'); Insert into saikat6 values('p008','dvd writer','frontec_org','5118.80','5120.40','DVDRW'); Insert into client6 values('cn01001','alak roy','b.d.para','amarpur','799101','tripura','390.9'); Insert into client6 values('cn01002','suman roy','puk para','agartala','799102','tripura','2390.9'); Insert into client6 values('cn01004','priya das','chora para','kamalpur','799301','tripura','1390.9'); Insert into client6 values('cn01005','mita mia','kamal para','singur','799721','tripura','190.9'); Insert into client6 values('cn01006','pulak roy','bircity','sonitpur','799141','assam','110.9'); Insert into client6 values('cn01007','munni das','nappam','sonitpur','799152','assam','190.9'); Insert into client6 values('cn01008','kusum roy','city_dos','tezpur','799141','assam','110.9'); Insert into client6 values('cn01009','mina das','pachmile','tezpur','799152','assam','190.9'); Insert into client6 values('cn01003','moytree nayak','pachmile','tezpur','799152','assam','9990.9'); Insert into client6 values('cn01010','pauri mia','pachmile','tezpur','799152','assam','2990.9'); Insert into client6 values('cn01011','manali das','satmile','tezpur','799154','assam','3990.9'); Insert into salesman6 values('s001','Rohan das','nappam','Tezpur','79970','Assam','8000'); Insert into salesman6 values('s002','Rohan das','nappam','Tezpur','799170','Assam','8000'); Insert into salesman6 values('s003','Smita das','nirjuli','itanagar','799701','Arunachal','9000'); Insert into salesman6 values('s004','Kabir bora','nappam','Tezpur','799703','Assam','8500'); Insert into salesman6 values('s005','Neha singh','borbota','sonitpur','795970','assam','9600'); Insert into salesman6 values('s006','Priya agarwal','gandhi road','32 distric','799750','delhi','9900'); Insert into salesman6 values('s007','Ashok Paul','filmcity','munnabari','799740','mumbai','8900'); Insert into sales_order_details6 values('on01001','01-aug-2008','cn01001','s001','yes','20-aug-2008','2220.40','50','28-march-2008'); Insert into sales_order_details6 values('on01002','12-aug-2008','cn01004','s001','yes','23-aug-2008','2220.40','15','28-march-2008'); Insert into sales_order_details6 values('on01003','12-aug-2008','cn01005','s003','yes','26-aug-2008','2220.40','10','28-march-2008'); Insert into sales_order_details6 values('on01004','13-aug-2008','cn01004','s001','yes','20-aug-2008','2220.40','15','28-march-2008'); Insert into sales_order_details6 values('on01005','14-aug-2008','cn01002','s002','no','30-aug-2008','2220.40','52','28-march-2008'); Insert into sales_order_details6 values('on01006','15-aug-2008','cn01001','s001','yes','31-aug-2008','2220.40','53','28-march-2008'); Insert into sales_order_details6 values('on01007','16-jan-2008','cn01003','s004','yes','28-aug-2008','2220.40','54','28-march-2008'); Insert into sales_order_details6 values('on01008','01-feb-2008','cn01004','s003','no','28-aug-2008','8220.40','54','18-march-2008');
run
|
edit
|
history
|
help
0
Rakibul Haque
cs
join tables multiple columns
lab_dop_for_mysql
MySQL Sandbox: Superheroes
Práctica MySQL 1
Test
pets
busID
flujo1