MySQL row with table name

Question

I want to ask how to show the table name along your data. For example, I have 2 tables.

TV show

id (int) title (varchar) release_date (date) 

Films

 id (int) title (varchar) release_date (date) 

I would like to display

 id title release_date table_name 

So the question is how to display table name data. Thanks:)

Answer 1

Just try:

 SELECT id, title, release_date, 'TV shows' as table_name FROM `TV shows` UNION ALL SELECT id, title, release_date, 'Movies' as table_name FROM `Movies`