25 авг. 2008 г. · Try: INSERT INTO table1 ( column1 ) SELECT col1 FROM table2 This is standard ANSI SQL and should work on any DBMS.

20 мар. 2013 г. · just use a subquery right there like: INSERT INTO table1 VALUES ("A string", 5, (SELECT ...)). INSERT INTO TABLE1 (COL1 , COL2,COL3) values ('A ...

10 нояб. 2017 г. · In general, insert . . . select is more general than insert . . . values(). I prefer the former because it is more powerful and more useful in more situations.

16 июн. 2014 г. · Try this INSERT INTO db_example.tab_example (id,name,surname) SELECT id,first_name,'M. Nega' FROM db_contacts.tab_mygroup You can use join in the FROM clause. ...

21 нояб. 2014 г. · Simply enclose the select with parenthesis: INSERT INTO SMS(N_SMS, CODIGO_CLIENTE) VALUES (SEQ_SMS.NEXTVAL , (SELECT CODIGO_CLIENTE FROM ...

5 окт. 2014 г. · Use insert . . . select : INSERT INTO history(col1, col2, col3) SELECT t_col1, 5, 76 FROM tabl2; The values keyword is not needed.

29 сент. 2016 г. · I would like to insert custom values along with table columns when i perform INSERT INTO ...SELECT FROM ... WHERE clause.

11 июл. 2011 г. · SELECT Locks the table while the insert is being made. therefore the table cannot be used for other processes at the same time.

13 мая 2009 г. · You will need to join the tables that you want to make the selection from. Here is a resource on SQL joins: www.w3schools.com/sql/sql_join.asp

15 нояб. 2013 г. · I'm trying to insert some values into a table from a select statement and some hardcoded values, but I'm not sure what the syntax would be.