1.语法
INSERT INTO table(column1,column2...)
VALUES (value1,value2,...);
语法释义
- 在INSERT INTO之
后跟表名,括号内跟字段,逗号分隔;
- 在VALUES
跟值;
2. 举个例子
INSERT INTO tasks(subject,start_date,end_date,description)
VALUES(‘Learn MySQL INSERT’,’2017-07-21’,’2017-07-22’,’Start learning..’);
,这是插入单行,如果是插入多行,这是这样:
INSERT INTO tasks(subject,start_date,end_date,description)
VALUES(‘Learn MySQL INSERT’,’2017-07-21’,’2017-07-22’,’Start learning..’),
(‘Learn MySQL INSERT’,’2017-07-21’,’2017-07-22’,’Start learning..’),
(‘Learn MySQL INSERT’,’2017-07-21’,’2017-07-22’,’Start learning..’)
(‘Learn MySQL INSERT’,’2017-07-21’,’2017-07-22’,’Start learning..’);
,对滴,就是诣逗号分隔。