/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

16 votes305 views1 answer
Mssql int max value
SQL
8 votes323 views1 answer
Oracle add datafile to tablespace
SQL
0 vote316 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote335 views1 answer
Dataframe lambda elif
SQL
0 vote294 views1 answer
How to create an SQL save method in ruby
SQL
3 votes283 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote309 views1 answer
Set root password mysql xampp
SQL
6 votes289 views2 answers
Return columns from table sql
SQL
1 vote247 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote310 views1 answer
Connecting to my cloud sql server with c#
SQL

Share