MySQL/SQL文

SQL文 †

都道府県SQL †

※手書きでSQL書くことが少なくなったので、よく忘れるのでメモです。

DROP TABLE prefectural;
CREATE TABLE prefectural (
  prefectural_id INT  NOT NULL AUTO_INCREMENT,
  prefectural_name VARCHAR(100) NOT NULL,
  prefectural_insert DATETIME NOT NULL,
  prefectural_update TIMESTAMP NOT NULL DEFAULT NOW(),
  PRIMARY KEY(prefectural_id)
)
INSERT INTO prefectural (prefectural_name) VALUES ('北海道'); 
INSERT INTO prefectural (prefectural_name) VALUES ('青森県');
INSERT INTO prefectural (prefectural_name) VALUES ('岩手県');
INSERT INTO prefectural (prefectural_name) VALUES ('宮城県');
INSERT INTO prefectural (prefectural_name) VALUES ('秋田県');
INSERT INTO prefectural (prefectural_name) VALUES ('山形県');
INSERT INTO prefectural (prefectural_name) VALUES ('福島県');
INSERT INTO prefectural (prefectural_name) VALUES ('茨城県');
INSERT INTO prefectural (prefectural_name) VALUES ('栃木県');
INSERT INTO prefectural (prefectural_name) VALUES ('群馬県');
INSERT INTO prefectural (prefectural_name) VALUES ('埼玉県');
INSERT INTO prefectural (prefectural_name) VALUES ('千葉県');
INSERT INTO prefectural (prefectural_name) VALUES ('東京都');

Comment †

• 北海道 -- 2017-05-01 (月) 10:51:30