01.
CREATE
TABLE
`area1` (
02.
`building`
varchar
(20) ,
03.
`floor`
varchar
(20) ,
04.
`room`
varchar
(20)
05.
);
06.
07.
INSERT
INTO
`area1`
VALUES
(
'มารี1'
,
'1'
,
'101'
);
08.
INSERT
INTO
`area1`
VALUES
(
'มารี1'
,
'1'
,
'102'
);
09.
INSERT
INTO
`area1`
VALUES
(
'มารี1'
,
'1'
,
'103'
);
10.
INSERT
INTO
`area1`
VALUES
(
'มารี1'
,
'1'
,
'104'
);
11.
INSERT
INTO
`area1`
VALUES
(
'มารี1'
,
'2'
,
'201'
);
12.
INSERT
INTO
`area1`
VALUES
(
'มารี1'
,
'3'
,
'301'
);
13.
INSERT
INTO
`area1`
VALUES
(
'มารี1'
,
'3'
,
'302'
);
14.
INSERT
INTO
`area1`
VALUES
(
'ยาดา1'
,
'1'
,
'101'
);
15.
INSERT
INTO
`area1`
VALUES
(
'ยาดา1'
,
'2'
,
'201'
);