MySql gets the sql statement for which table a field exists

  • 2020-05-30 21:12:22
  • OfStack

 
SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'col1' 

col1 is the subsegment name.

Related articles: