Mysql中表student_info(id,name,birth,sex),字段类型都是varchar,插入如下记录:('1014' , '张三' , '2002-01-06' , '男');
SQL错误的是()?
insert into student_info values('1014' , '张三' , '2002-01-06' , '男');
insert into table student_info values('1014' , '张三' , '2002-01-06' , '男');
insert into student_info(id,name,birth,sex) values('1014' , '张三' , '2002-01-06' , '男');
insert into student_info(id,name,sex,birth) values('1014' , '张三' , '男','2002-01-06' );
普通插入(全字段):INSERT INTO table_name VALUES (value1, value2, ...)
普通插入(限定字段):INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...)
多条一次性插入:INSERT INTO table_name (column1, column2, ...) VALUES (value1_1, value1_2, ...), (value2_1, value2_2, ...), ...
从另一个表导入:INSERT INTO table_name SELECT * FROM table_name2 [WHERE key=value]