CUBRID学习笔记 22 插入数据

?

CREATE TABLE auto_tbl(id INT AUTO_INCREMENT, name VARCHAR);<br><br>自增长的列可以插入null, 同时一次可以插入多条记录.别的和其他的sql数据库语法基本一样

?

INSERT INTO auto_tbl VALUES (NULL, 'AAA');

INSERT INTO auto_tbl (id, name) VALUES (NULL, 'AAA');

INSERT INTO auto_tbl (name) VALUES ('DDD');<br><br>

?

1 2 3

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