New took over the project, the data quantity is large, and there is no data field, only know that part of the content of the field, the field name also don't know, want to ask you how to find the corresponding table according to the known field content

CodePudding user response:

Not according to the content of the field to find out the corresponding table,
For example, I give my data is as follows:
1 'shenzhen nanshan district'
2 ', '
shenzhen top talent marketCan you tell me the two rows of data corresponding to the field of is what? What is the name of the table?

CodePudding user response:

The field name is known, to search the table name, is the way to do it,

CodePudding user response:

Advanced to the library to find all the name of the table, then watch table structure, so no?

CodePudding user response:

It's really not a good idea,
If you are a DBA, definitely shouldn't do it, even see, also don't know business relations,
If you are a system operations staff, should begin from the front desk,

CodePudding user response:

reference wandier reply: 3/f

advanced to library, find out all the name of the table, and then see the table structure, so no?

Not sure, if I have 1000 form? Each one to see the table structure? Many large projects are now at 2000-3000 table, table of up to 6000-7000,

CodePudding user response:

The landlord if you really have such demand, there are other pre-conditions or environment?
Different table fields can have the same value, the name what is not to say, Numbers, time field has the same value not too simple

CodePudding user response:

All the data in the table, export into SQL format, and then in the text query,