1.表中插入一行数据:
INSERT INTO table_name
VALUES ('value1', 'value2',....)
2.向表中插入多行:
INSERT INTO table_name ('COLUMN1, 'COLUMN2',...)
VALUES ('value1', 'value2',....),
VALUES ('value1', 'value2',....),
VALUES ('value1', 'value2',....),
INSERT INTO table_name ('COLUMN1, 'COLUMN2',...) SELECT VALUES ('value1', 'value2',....) union SELECT VALUES ('value1', 'value2',....) union SELECT VALUES ('value1', 'value2',....)
3.表中指定列插入数据:
INSERT INTO table_name ('COLUMN1, 'COLUMN2',...) VALUES ('value1', 'value2',....)
4.从另一个或多个表向一个表插入数据:
insert into table_name [('COLUMN1, 'COLUMN2',...)] select [('COLUMN1, 'COLUMN2',...)] from table [where condition(s)
例子: insert into PreprocessData ( Age, Sex , Score ) select PreprocessData2018.Age, PreprocessData2018.Sex , PreprocessDataVector17.Score from reprocessData2018,PreprocessDataVector17 where PreprocessDataVector17.ID =PreprocessData2018.ID insert into PreprocessData select * from reprocessData2018