Question

I have querry in mySQL, i suspect that another table also has the same output as my querry. I dont have an idea of what this tables name is. is there a way i can look for a table based on the output? this is in MySQL

Answer 1

In MySQL, to find a table based on its output, you can use SQL queries to compare known data or query structure against the INFORMATION_SCHEMA tables for similar columns or data types. This process involves using SELECT statements to identify potential tables that match the criteria and then manually examining those tables.

Step-by-step explanation:

In MySQL, there is no direct way to find a table based on output alone. However, if you suspect that another table may contain similar data or structure, you can use some SQL queries to get information about all your tables. For example, you can query the INFORMATION_SCHEMA tables which contain database metadata. You could compare some known values or your query's structure to the columns and data types in other tables by using the INFORMATION_SCHEMA.COLUMNS table.

To do this, you would write a SELECT statement that looks for columns with similar names, types, or other identifying characteristics that match the output of your query. This process could be time-consuming and would involve some trial and error:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='column_name_you_know' AND DATA_TYPE='data_type_of_column';

This SQL query would return a list of tables that have a column with the specified name and data type. You'd then have to examine these tables manually to see if their data matches your query's output. It's also important to have proper permissions to access the INFORMATION_SCHEMA.