DML
向表中插入数据
INSERT INTO userinfo VALUES(0,'张三','女','15511111113',DEFAULT,1)
INSERT INTO userinfo VALUES(2,'张三','女','15511111113',DEFAULT,1)
INSERT INTO userinfo VALUES(NULL,'张三','女','15511111113',DEFAULT,1)
INSERT INTO userinfo VALUES(0,'张三','女','15511111113',0,1)
INSERT INTO userinfo VALUES(0,'张三','女','15511111113',DEFAULT,1)
INSERT INTO userinfo VALUES(0,'张三','女','15511111113',NULL,1)
INSERT INTO userinfo(name,gender,phone,address) VALUES('张三','女','15511111111',1)
INSERT INTO userinfo(name,gender,phone,address) VALUES('张三','女','18336900001',1),
('李四','男','18336900002',1),('王二','男','18336900003',1);
INSERT INTO userinfo SET name='李四',gender='男',phone='18336900004',age=DEFAULT,address=1;
总结