Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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';
Source by tableplus.com #
 
PREVIOUS NEXT
Tagged: #mysql #select #table #field #names
ADD COMMENT
Topic
Name
6+7 =