Versions Compared

Old Version 3

changes.mady.by.user Anhei Shu

Saved on

compared with

New Version 4

changes.mady.by.user Anhei Shu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel

mysql> SHOW FULL PROCESSLIST;
mysql> KILL theprocessid;

Some useful SQL commands

...

Find Duplicates of a field set

...

Panel

mysql> select *, count(star) as count from table-name group by field1, field2, ... having count(star) >1;
select * from table-name group by field1 having count(word)>1;