Well, doing on all tables at once woule probably bring the server to its knees
due to the cartesian product producing a VERY large temporary table. You can
do it on two tables at once like this (if my memory serves):
SELECT * from mytable as t1, mytable as t2
WHERE t1.column1 = t2.column1 AND
Thanks for the response, Joshua.
I am so very new to MySQL, that I am afraid I require more guidance.
Is there a way to join ALL tables in a database rather than just one table
to itself, or one particular table to another?
SELECT * FROM allTables WHERE column1=column1 AND column2=column2 AND
co
Yes, there is a way. It's called joins. :) I don't remember the exact syntax
off the top of my head, but the approach is thus:
Do a self join on the table and select records that match in their first three
columns, but do not have the same primary key (you *do* have primary keys on
your table
Is there a way to use a SELECT statement (or any other, for that matter)
that will look at every table in a database and return every row whose first
3 columns are duplicated in at least one other row in any of the tables?
Essentially, a command to find duplicate entries in the database . . .
Than
