· 7 years ago · Oct 26, 2018, 07:38 AM
1
2CREATE TABLE IF NOT EXISTS `salesmaster` (
3 `salesid` varchar(30) NOT NULL,
4 `description` varchar(20) NOT NULL,
5 `quantity` int(11) NOT NULL,
6 `price` int(11) NOT NULL
7) ENGINE=MyISAM DEFAULT CHARSET=latin1;
8
9--
10-- Dumping data for table `salesmaster`
11--
12
13INSERT INTO `salesmaster` (`salesid`, `description`, `quantity`, `price`) VALUES
14('001', 'Mouse', 10, 50),
15('002', 'KeyBoard', 2, 51),
16('003', 'Phone', 1, 500),
17('004', 'Data Cable', 3, 69),
18('005', 'Pointer', 2, 105),
19('006', 'Board', 2, 21);