Sql

INSERT INTO TABLE1 (id, col_1, col_2, col_3)
SELECT id, 'data1', 'data2', 'data3'
FROM TABLE2
WHERE col_a = 'something';

PREVIOUS	NEXT

Code Example
Sql :: mysql select if empty result
Sql :: sql server query all database objects
Sql :: column get from sql table
Sql :: select all tables sql
Sql :: allow external access to mysql
Sql :: sql unique rows
Sql :: install mysql workbench ubuntu 20.04
Sql :: oracle trigger after connect
Sql :: How to Find Duplicate Values in a SQL Table
Sql :: how to get nears location in mysql with latitude and longitude
Sql :: give a column name to values generated from case statement in sql
Sql :: Alter table add column in SQL Server- NAYCode.com
Sql :: plsql triggers
Sql :: update using case in mysql
Sql :: how to change column name in sql
Sql :: postgres set column equal to another
Sql :: how to find database collation in postgres
Sql :: sql server list locks
Sql :: how to check the mysql version mac
Sql :: describe table postgres
Sql :: if else in plsql
Sql :: sql compare strings
Sql :: sqlite show table indexes
Sql :: sql foreign key
Sql :: sql concat
Sql :: oracle running queries sql
Sql :: current timestamp in milliseconds mysql
Sql :: how to combine diff colmun value using group by postgres
Sql :: Select without null values sql
Sql :: primary key multiple