/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 vote347 views2 answers
Check mysql timezone
SQL
0 vote346 views1 answer
Get only structure database mysql
SQL
0 vote350 views1 answer
Trigger stock phpmyadmin output message
SQL
10 votes390 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote357 views1 answer
Normalization in database 2nd normal form
SQL
0 vote364 views1 answer
Case insensitive sql
SQL
11 votes349 views5 answers
How to install sqlite3 python
SQL
2 votes362 views2 answers
Change mysql password from command line
SQL
8 votes367 views2 answers
Alert table name mysql
SQL
1 vote355 views1 answer
Does insert into overwrite sql
SQL

Share