大家好,又见面了,我是你们的朋友全栈君。
INSERT INTO target_table (col1, col2, col3)
SELECT col1,
col2,
col3
FROM source_table
WHERE condition;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/159630.html原文链接:https://javaforall.net
Oracle INSERT INTO SELECTINSERTINTOtarget_table(col1,col2,col3)SELECTcol1,col2,col3FROMsource_tableWHEREcondition;
大家好,又见面了,我是你们的朋友全栈君。
INSERT INTO target_table (col1, col2, col3)
SELECT col1,
col2,
col3
FROM source_table
WHERE condition;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/159630.html原文链接:https://javaforall.net