Search
 
SCRIPT & CODE EXAMPLE
 

SQL

insert into using contant values and source table columns with sql

INSERT INTO table1(user_uuid, login_id)
SELECT users_uuid, '1234' FROM table2 WHERE first_name LIKE 'ortal';
Comment

PREVIOUS NEXT
Code Example
Sql :: alter table myisam to innodb 
Sql :: SQL Server Altering Column to be Unique 
Sql :: how to get date in sql 
Sql :: mysql remove auto increment 
Sql :: sql server to uppercase 
Sql :: postgres like case insensitive 
Sql :: mysql order by two columns priority 
Sql :: find usage of table in sql server 
Sql :: grant all privileges microsoft sql 
Sql :: mssql datetime to date 
Sql :: oracle list proxy users 
Sql :: create temp table in sql 
Sql :: python dictionary to sql update 
Sql :: Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘a’. 
Sql :: mysql set boolean default value 
Sql :: sub query in linq 
Sql :: sequence postgresql 
Sql :: duplicate key value violates unique constraint in postgresql 
Sql :: codeigniter get sql query string 
Sql :: sql get first letter of string 
Sql :: postgres role does not exist 
Sql :: sql query to check if column contains alphabets 
Sql :: sql server 2019 installation 
Sql :: reset keys in sql 
Sql :: count the table indatabase 
Sql :: postgres create database if not exists 
Sql :: oracle list primary key 
Sql :: postgresql concat string with separator 
Sql :: between 
Sql :: sql unique constraint 
ADD CONTENT
Topic
Content
Source link
Name
8+5 =