01.CREATE TABLE IF NOT EXISTS `customer` (
02.`CustomerID` varchar(4) NOT NULL,
03.`Name` varchar(50) NOT NULL,
04.`Email` varchar(50) NOT NULL,
05.`CountryCode` varchar(2) NOT NULL,
06.`Budget` double NOT NULL,
07.`Used` double NOT NULL,
08.PRIMARY KEY (`CustomerID`)
09.) ENGINE=MyISAM DEFAULT CHARSET=utf8;
10.
11.--
12.-- dump ตาราง `customer`
13.--
14.
15.INSERT INTO `customer` (`CustomerID`, `Name`, `Email`, `CountryCode`, `Budget`, `Used`) VALUES
16.('C001', 'Win Weerachai', 'win.weerachai@thaicreate.com', 'TH', 1000000, 600000),
17.('C002', 'John Smith', 'john.smith@thaicreate.com', 'UK', 2000000, 800000),
18.('C003', 'Jame Born', 'jame.born@thaicreate.com', 'US', 3000000, 600000),
19.('C004', 'Chalee Angel', 'chalee.angel@thaicreate.com', 'US', 4000000, 100000);