Using MySQL. Is there a simple way to find duplicate rows based on a
column?
Thanks
Steve Fogelson
To unsubscribe from this list, please send an email to lists...@witango.com
with unsubscribe witango-talk in the body.
Steve,
Standard SQL HAVING clauses should work:
SELECT columnname, COUNT (*) FORM tablename
GROUP BY columnname
HAVING COUNT (*) 1
On Wed, Sep 14, 2011 at 11:07 AM, Fogelson, Steve
stevefogel...@askics.netwrote:
Using MySQL. Is there a simple way to find duplicate rows based on a
Oops. Misspelled FROM. Sorry.
On Wed, Sep 14, 2011 at 11:26 AM, Bill Downall
bdown...@downallconsulting.com wrote:
Steve,
Standard SQL HAVING clauses should work:
SELECT columnname, COUNT (*) FORM tablename
GROUP BY columnname
HAVING COUNT (*) 1
On Wed, Sep 14, 2011 at 11:07 AM,
I notice that I have a sql.log file that is 20G. It's being updated
continuously, as the file is open. Not healthy. I figure I need to turn down
the logging on mysql or turn it off.
I get the system variables and see that log, log_update, log_bin, etc., are
all OFF
Anyone know what I can do to