插入
https://www.runoob.com/mysql/mysql-insert-query.html
- 一次插入多个值
INSERT INTO table_name (field1, field2,...fieldN)
VALUES
(valueA1,valueA2,...valueAN),
(valueB1,valueB2,...valueBN),
(valueC1,valueC2,...valueCN)......;
- 省略列名,需要所有的列都按顺序插入
INSERT INTO table1 VALUES (0, "JAVA 教程", "RUNOOB.COM", '2016-05-06');
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
编辑 (opens new window)
上次更新: 2021/10/11, 12:43:58