hr80ynuA

1DROP DATABASE  IF EXISTS `dbsales`;
2
3CREATE DATABASE `dbsales` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
4use dbsales ;
5
6CREATE TABLE `salesmaster` (
7  `salesid` varchar(30) NOT NULL,
8  `salesdate` datetime DEFAULT NULL,
9  `description` varchar(30) DEFAULT NULL,
10  `totalprice` double DEFAULT NULL,
11  PRIMARY KEY (`salesid`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
13
14CREATE TABLE `salesdetails` (
15  `salesid` varchar(30) NOT NULL,
16  `proddesc` varchar(30) DEFAULT NULL,
17  `qty` int(11) DEFAULT NULL,
18  `upride` double DEFAULT NULL,
19  `totalprice` double DEFAULT NULL
20) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
21
22
23insert into salesmaster ()
24values('S001', now(), 'Optical Mouse', '100.00' );
25
26insert into salesdetails() values 
27('S001', 'Wired Mouse 0123', '1', '50.00', '50.00'  ),
28 ('S001', 'Wireless Mouse 8975', '1', '50.00', '50.00'  );
29 
30 insert into salesmaster ()  values('S002', now(), 'Keyboard', '500.00' );
31
32
33insert into salesdetails()  values 
34('S002', 'No Key board', '5', '50.00', '250.00'  ),
35 ('S002', 'Old board ', '2', '75.00', '150.00'  ),
36 ('S002', 'KeyHand ', '1', '100.00', '100.00'  );
37 
38 Select * from salesmaster;
39 Select * From salesdetails;