CREATE DATABASE fooddb;

USE fooddb;

CREATE TABLE foodtable (
  city CHAR(6) NOT NULL,
  cityarea VARCHAR(10) NOT NULL,
  storename VARCHAR(254) NOT NULL
);

INSERT INTO foodtable (city,cityarea,storename) VALUES ('台北市','大安區','麵屋元');
INSERT INTO foodtable (city,cityarea,storename) VALUES ('台南市','善化區','慈光烏橋牛肉麵');
INSERT INTO foodtable (city,cityarea,storename) VALUES ('高雄市','新興區','九日拉麵');
INSERT INTO foodtable (city,cityarea,storename) VALUES ('雲林縣','土庫鎮','怪人花枝鱔魚麵');
INSERT INTO foodtable (city,cityarea,storename) VALUES ('台北市','北投區','北投林家涼麵');