01.
CREATE
TABLE
`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.
FULLTEXT
KEY
`
Name
` (`
Name
`,`Email`)
10.
) ENGINE=MyISAM
DEFAULT
CHARSET=utf8;
11.
12.
13.
14.
15.
16.
INSERT
INTO
`customer`
VALUES
(
'C001'
,
'Win Weerachai'
,
'win.weerachai@thaicreate.com'
,
'TH'
, 1000000, 600000);
17.
INSERT
INTO
`customer`
VALUES
(
'C002'
,
'John Smith'
,
'john.smith@thaicreate.com'
,
'EN'
, 2000000, 800000);
18.
INSERT
INTO
`customer`
VALUES
(
'C003'
,
'Jame Born'
,
'jame.born@thaicreate.com'
,
'US'
, 3000000, 600000);
19.
INSERT
INTO
`customer`
VALUES
(
'C004'
,
'Chalee Angel'
,
'chalee.angel@thaicreate.com'
,
'US'
, 4000000, 100000);