/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

-1 vote257 views1 answer
MYSQL stored procedure select from
SQL
3 votes260 views1 answer
How to remove characters from string in mysql
SQL
1 vote244 views1 answer
Sql myisam vs innodb
SQL
2 votes290 views2 answers
Oracle create table if not exists
SQL
8 votes289 views4 answers
Postgresql server restart
SQL
0 vote261 views1 answer
Soql more than today
SQL
0 vote254 views1 answer
If null don't update
SQL
12 votes289 views5 answers
Rename table in mysql
SQL
0 vote268 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote252 views1 answer
Wordpress sql change site url
SQL

Share