Search
 
SCRIPT & CODE EXAMPLE
 

SQL

insert into table from another table mysql

INSERT INTO table1 (emp_id, fname)
SELECT emp_id, fname 
FROM table2
WHERE status = 'Active';
Comment

PREVIOUS NEXT
Code Example
Sql :: update data with random values postgres 
Sql :: how to see all table partition in oracle 
Sql :: insert current timestamp in postgresql 
Sql :: mssql int max value 
Sql :: how to install sqlite3 python 
Sql :: sql update from select 
Sql :: get current date data in mysql 
Sql :: sql get number of days between two dates 
Sql :: firebase bigquery cloud message 
Sql :: power query concatenate 
Sql :: LoadError: cannot load such file -- mysql2/2.7/mysql2 
Sql :: mysql reset auto increment id 
Sql :: spark sql convert string to date 
Sql :: go install mysql 
Sql :: mysql select where text contains 
Sql :: get week day name sql server 
Sql :: mysql update set sum 
Sql :: find logged in users mysql 
Sql :: oracle grant on all tables in schema 
Sql :: create function in microsoft sql server 
Sql :: mysql pretty date format 
Sql :: mysql create timestamp column 
Sql :: oracle sessions_per_user limit 
Sql :: docker mysql random root password 
Sql :: oracle undo usage 
Sql :: sql select where in list 
Sql :: racle create auto increment column 
Sql :: postgresql today - 1 year 
Sql :: mysqldump: Got error: 1045: Access denied for user 
Sql :: sql server update column based on another table 
ADD CONTENT
Topic
Content
Source link
Name
3+8 =