This article describes in detail which table of a field is queried through MySql. The specific SQL statement is as follows. If you are interested, refer, we hope to help you copy the code as follows: SELECTTABLE_SCHEMA, TABLE_NAMEFROMinformation_schema. 'columns 'WHERECOLUMN _ NAMEcol1col1 is child
This article gives you a detailed description of the table where a field is located through MySql. The specific SQL statement is as follows. If you are interested, refer to it. The code you want to help you with is as follows: SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema. 'columns' WHERE COLUMN_NAME = 'col1' col1 is a child
This article gives you a detailed description of the table where a field is located through MySql. The specific SQL statements are as follows. If you are interested, refer to them and hope to help you.
The Code is as follows:
SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema. 'columns 'WHERE COLUMN_NAME = 'col1'
Col1 is the child segment name.