I have 50 databases in mysql, there is an one specific column called product_number in all of them(databases and tables),but the name of the tables are different, is there anyway to select or show them all?
as you know better than me in each database and table I can easily show them with this command :
SELECT product_number
FROM 'products'
LIMIT 50
but what about the others ?
for example :
use *
SELECT product_number
FROM *
how is it possible ?