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 †
Counter: 12820,
today: 1,
yesterday: 0
|