06插入数据

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)...