create database sample;
show databases;
use sample;
CREATE TABLE T01Prefecture (
PREF_CD INT(3),
PREF_NAME VARCHAR(10),
PRIMARY KEY (PREF_CD)
);
select * from to1prefecture;
insert into to1prefecture(PRED_CD,PREF_NAME) VALUES(1,'hokkaido');
insert into to1prefecture VALUES(2,'aomori');
insert into to1prefecture(PREF_NAME,PREF_CD) VALUES('iwate',3);
insert into to1prefecture(PRED_CD,PREF_NAME)
VALUES(4,'miyagi'),(5,'aktia'),(6,'yamagata');
insert into to1prefecture set PREF_CD = 7,PREF_NAME='hukushima';
mysqlweb.net