how to show all table column names in mysql code example
Example: mysql select all table that have field names
SELECT DISTINCT
TABLE_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
COLUMN_NAME IN('column1', 'column2')
AND TABLE_SCHEMA = 'schema_name';