Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to combine 2 tables in MySQL

create table yourTableName
(
   select *from yourTableName1
)
UNION
(
   select *from yourTableName2
);
Comment

mysql join two tables

SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations
Comment

PREVIOUS NEXT
Code Example
Sql :: sql vs nosql or mysql vs mongodb 
Sql :: how to find top 3 salary in sql 
Sql :: android sqlite query join 
Sql :: finish transaction sql 
Sql :: how to get max from each department in sql 
Sql :: setval in postgres 
Sql :: delete vs truncate sql server 
Sql :: oracle find foreign key dependencies 
Sql :: sql server datetime 
Sql :: sql composite key 
Sql :: mysql decimal remove trailing zeros 
Sql :: Mysql table variables 
Sql :: copy table in sql 
Sql :: SQL Server OPENJSON FROM table column 
Sql :: sql server set default value equal to auto increment 
Sql :: sql 2 way of select unique 
Sql :: mysql replace regex 
Sql :: get size of mysql database 
Sql :: mysql string split to array 
Sql :: dump sql file to database postgres 
Sql :: generate series sybase 
Sql :: oracle list user locked 
Sql :: update field in sql to null 
Sql :: sqlite löschen einer tabelle 
Sql :: select multiple tables mysql 
Sql :: SQL:RANK function to delete duplicate rows 
Sql :: sql union 
Sql :: how to completely uninstall sql server 
Sql :: get month from date sql server 
Sql :: what is between keyword used for 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =