1.所有列插入值
INSERT[INTO] table_name VALUES(V1,V2...Vn)
特点：列值同数，列值同序（即：一一对应）
示例：
insert into users
values
("20020101","周伯通","男","1960-01-01","1381111222")
insert into users
values
("20020101","周伯通",default,"1960-01-01","1381111222")
2.为特定列插入值
INSERT[INTO] table_name （col1,col2...coln）VALUES(V1,V2...Vn)
特点：指定顺序，列值对应
INSERT INTO users(user_qq,user_name,user_mobile)
VALUES('12301','叮当','男','1998-03-07','1377799805'
3.一次性插入多条数据
INSERT[INTO] table_name （col1,col2...coln)
VALUES
(V1,V2...Vn),
(V21,V22...V2n)...