How to join results with UNION in MySQL? free example, tutorial, source code

home page latest news web development curriculum vitae scripts contact me

• C# (Microsoft .NET)
• JAVA
• Dynamic HTML
• PHP & MySQL
• ASP.NET - C# & VB.NET
• Perl & CGI
• C | C++
• Vector Markup Language
• SMIL
• Assembler
• Databases
• Wap Development
• Web site promotion
• Web Marketing

Blog System

Real Estate Portal

Jobs Portal v1.3

Car Portal v2.0

PHP Mall v2.0

WebSiteAdmin.biz

How to join results with UNION in MySQL?

(Free programming example written by Anton Zamov.
Find more free examples on "The ultimate source for developers" )

The UNIONs were introduced in MySQL 4. The unions
are useful if you wish to join the results from more
than one query, but be aware that the number of the returned
columns by each select query should be the same.
(as well as their type)

The very simple example below show you the basics of the UNION
statement

SELECT id, name FROM my_table
UNION
SELECT id, name FROM my_table;

Jobs Portal, poweful jobs board software

PHP Mall, multi vendors mall website software

Car Portal, php script for auto classifieds websites

NetArt Media, software products and services

Real Estate Portal, web software for real estate portals

Blog System, multi user blog hosting script

PHP Store, powerful e-commerce system written in PHP