Find underlying table name from view

[eludlow]

Hi all.

I've a table that UNIONs 12 tables together. I then have a query (call it x) that will identify one row in this view (so it could be in one of 12 tables). I then need to update one field in that one row.

I can't update the view, as it contains UNION.

Is there a way I can get mysql to tell me the name of the table that contains a row of data from the view?

This will make the update query a lot simple. Otherwise, I will have to search EACH of the 12 tables for the row returned by my first query (x) and then update based on the table returned by that.

Thanks,
Ed

[dagon]

somewhat unclear, but i think in the view you could add a col called DB and populate it wit the view so in each of the union add 'db_name' as DB

select , 'people' as DB from people
union
select , 'places' as DB from places

etc