/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

15 votes204 views4 answers
Create table if not exists sql
SQL
0 vote209 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote209 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote199 views1 answer
How to find sql server installation folder
SQL
1 vote208 views2 answers
Mssql show database size
SQL
0 vote268 views1 answer
Inner join distinct
SQL
10 votes246 views2 answers
What is database
SQL
0 vote204 views1 answer
Sql query for displaying age from oldest to youngest
SQL
6 votes279 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote205 views1 answer
Ansi sql count duplicate rows
SQL

Share