/SQL/Get value from a table an insert it with other values in another table sql

Get value from a table an insert it with other values in another table sql

Get value from a table an insert it with other values in another table sql

INSERT INTO column_1 ( val_1, val_from_other_table ) 
VALUES('val_1', (SELECT  val_2 FROM table_2 WHERE val_2 = something))

0

Source: stackoverflow.com

Create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;

0

Source: stackoverflow.com

Similar codes

0 vote116 views1 answer
Update having mysql
SQL
1 vote123 views1 answer
Where date = max(date) in sql
SQL
0 vote135 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote117 views1 answer
Insert data from stored procedure into table
SQL
2 votes169 views1 answer
Select from array in psql
SQL
6 votes183 views2 answers
Non relational database
SQL
0 vote140 views1 answer
Get create sql of hibernqte entity
SQL
0 vote133 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote146 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote122 views1 answer
Sql server order by nulls last
SQL

Share