Combining data with different columns

suggest change

SELECT name, caption as title, year, pages FROM books 
UNION
SELECT name, title, year, 0 as pages FROM movies

When combining 2 record sets with different columns then emulate the missing ones with default values.

Found a mistake? Have a question or improvement idea? Let me know.

UNION:

*UNION

*Combining SELECT statements with UNION

*ORDER BY

*Pagination via OFFSET

*Combining data with different columns

*UNION ALL and UNION

*Combining and merging data on different MySQL tables with the same columns into unique rows and running query

Table Of Contents

0Getting started with MySQL

1Limit and Offset

2Creating Databases

3Backup using mysqldump

4Table Creation

5Insert

6Error Codes

7Stored routines, procedures and functions

8Reserved Words

9String operations

10Delete

11View

12Indexes and Keys

13Date and Time Operations

18Joins

19UPDATE

21JSON

25Configuration and tuning

26Converting from MyISAM to InnoDB

27SELECT

30UNION

34Events

35ENUM

36Install MySQL with Docker

37Arithmetic

38Character Sets and Collations

39MyISAM Engine

40Many-to-many Mapping table

41Using Variables

42Log files

43Partitioning

44Security via GRANTs

51MySQL Performance Tips

52Temporary Tables

53Transaction

54Customize PS1

55Dealing with sparse or missing data

56Dynamic Un-Pivot Table using Prepared Statement

57NULL

58Replication

59Connecting with UTF-8

60SSL Connection Setup

61Handling Time Zones

62Time with subsecond precision

63Error 1055 ONLY FULL GROUP BY

64Full-Text search

65Extract values from JSON type

66Regular Expressions

67Recover and reset default root password

68One to Many

69JOINS Join 3 tables

70Server Information

71Recover from lost root password

72Contributors