/SQL/Mysql select all table that have field names

Mysql select all table that have field names

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';

0

Source: tableplus.com

Similar codes

0 vote191 views1 answer
Laravel migration sql dump
SQL
0 vote221 views1 answer
Composit key in sql
SQL
4 votes181 views1 answer
Oracle select first 10 rows
SQL
10 votes190 views2 answers
Show tables in schema oracle
SQL
1 vote191 views3 answers
Rows, INSERT INTO
SQL
1 vote223 views1 answer
Show per page table in xampp
SQL
0 vote179 views1 answer
Get duplicate entry sql
SQL
4 votes217 views1 answer
Mysql delete last row
SQL
0 vote167 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote187 views1 answer
Enable sql server full text indexing
SQL

Share