CUBRID学习笔记22插入数据

CREATE TABLE auto_tbl(id INT AUTO_INCREMENT, name VARCHAR);

自增长的列可以插入null, 同时一次可以插入多条记录.别的和其他的sql数据库语法基本一样

INSERT INTO auto_tbl VALUES (NULL, &＃39;AAA&＃39;);
INSERT INTO auto_tbl (id, name) VALUES (NULL, &＃39;AAA&＃39;);
INSERT INTO auto_tbl (name) VALUES (&＃39;DDD&＃39;);



INSERT INTO auto_tbl VALUES (NULL, &＃39;AAA&＃39;),(NULL, &＃39;BBB&＃39;),(NULL, &＃39;CCC&＃39;);
INSERT INTO auto_tbl (id, name) VALUES (NULL, &＃39;AAA&＃39;),(NULL, &＃39;BBB&＃39;),(NULL, &＃39;CCC&＃39;);
INSERT INTO auto_tbl (name) VALUES (&＃39;DDD&＃39;),(&＃39;EEE&＃39;);