With the following syntax
INSERT INTO table [(column [, column...])]
VALUES (value [, value...]);
you can:
1
Insert one row at a time
2
Insert multiple rows at a time
3
Insert one column at a time
4
Insert multiple columns at a time
5
All of the above