Answers for "mysql select all table that have field names"

SQL
0

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';
Posted by: Guest on November-12-2020

Code answers related to "mysql select all table that have field names"

Code answers related to "SQL"

Browse Popular Code Answers by Language