insert

標準方法

insert into TEST_T (ID_C,NAME_C,ADD_C) values (10,'TAKEUCHI','KYOTO');

省略

insert into TEST_T values(1.'TAKEUCHI','KYOTO');
insert into TEST_T values (8,'UNO','NAGASAKI');

順番バラバラで入力

insert into TEST_T (NAME_C,ADD_C,ID_C) values ('TAKEUCHI','KYOTO',9);

他の入力方法

insert into TEST_T set ID_C=4,NAME_C='TAKEUCHI',ADD_C='KYOTO';

一度にいれる方法

insert into TEST_T values (7,'TAKEUCHI','KYOTO'),(2,'UNO','NAGASAKI');
insert into TEST_T values (3,'HATA','OSAKA'),(6,'MATSUMOTO','SIGA');