/SQL/How to combine 2 tables in MySQL

How to combine 2 tables in MySQL

Mysql join two tables

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

1

How to combine 2 tables in MySQL

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

0

Source: tutorialspoint.com

Similar codes

1 vote300 views1 answer
Column with prefix in sql
SQL
3 votes202 views3 answers
How to add month in update sql
SQL
1 vote314 views1 answer
Python clean sql string
SQL
0 vote200 views1 answer
Doesn't have default value mysql
SQL
14 votes240 views2 answers
Sql cast
SQL
0 vote200 views1 answer
Stored procedures example
SQL
-1 vote214 views1 answer
Default username and password for oracle 11g
SQL
2 votes202 views4 answers
Mysql get all tables row count
SQL
0 vote356 views1 answer
How to find the most occuring in SQL
SQL
13 votes206 views2 answers
Get tables in database sql
SQL

Share