database - SQL Insert into ... values ( SELECT ... FROM ... ) - Stack Overflow

database - SQL Insert into ... values ( SELECT ... FROM ... ) - Stack Overflow

瀏覽:718
日期:2025-11-17
Both the answers I see work fine in Informix specifically, and are basically standard SQL. That is, the notation: INSERT INTO target_table[()] SELECT ... FROM ...; works fine with Informix and, I would expect, all the DBMS. (Once upon 5 or more ......看更多