Commanding Chaos for Coworking, Open Source and Creative Communities

Error message

  • Deprecated function: session_set_save_handler(): Providing individual callbacks instead of an object implementing SessionHandlerInterface is deprecated in drupal_session_initialize() (line 245 of includes/session.inc).
  • Deprecated function: Creation of dynamic property alpha_theme_container::$delta is deprecated in alpha_theme_container->__construct() (line 25 of sites/all/themes/contrib/omega/alpha/includes/base.inc).

How to find duplicate records in a table on database - SQL tips

Fri, 07/18/2014 - 06:50 -- rprice
Link: 
http://javarevisited.blogspot.com/2012/12/how-to-find-duplicate-records-in-table…

In this section we will see SQL query which can be used to locate duplicate records in table. As explained in previous section, definition of duplicate depends upon business rules which must be used in group by clause. In following query we have used SELECT query to select all records from Contacts table.

Tags: 
mysql