插入数据

-- 根据指定数据插入
INSERT INTO t_stu VALUES(2,"xiao","男");
INSERT INTO t_stu(id,name,sex) VALUES(3,"xo","男");
-- 根据字短可以不按照顺序插入
INSERT INTO t_stu(sex,id,name) VALUES("女",4,"hua")

错误写法

如果没有指定字短，顺序不能乱 否则报错

INSERT INTO t_stu VALUES("xo",5,"男");
-- 1366 - Incorrect integer value: 'xo' for column 'id' at row 1, Time: 0.016000s