Delete Duplicate Snippets


Use the same table to query against itself. The greater then sign does the main job of returning only one records of both duplicate records.

24 August, 2013   

MySQL code to find duplicate records in table

15 September, 2012   

This will perform the action of deleting many files.

An example of finding duplicate values in a table column

A simple DELETE statement in MSSQL

14 May, 2011   

This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...

SQL code example to delete WordPress post revision from DB

Confirm a deletion (or any action) with Javascript.

17 December, 2011   

In a table, some of the columns may contain duplicate values. Sometimes you will need to list only the different (distinct) values in a table. The DISTINCT keyword can be used to return only distinct (different) values.

22 January, 2012   

C++ example code for showing how to allocate and free memory

PHP’s rmdir function does not allow the deletion of a folder if it is not empty.

08 February, 2014   

How to set/get/delete Cookies

MySQL code to find all duplicates in a database column(s)n.

28 June, 2012   

Function to generate soundex code for any string (usually a name). Conforms to Knuth's algorithm and the common Perl implementation.

11 December, 2014   

C++ code snippet of simple stack using linked lists, can be used for database management system.

C++ source code for singly linked list - insert, remove, add, count

04 July, 2011   

Animation with threads by John E. Grayson

15 December, 2012   

Allows you monitor how many times a link/image/banner is clicked.

Adding VBA Code Programmatically in Excel

13 June, 2013   

Allows you yo monitor how many times a link/image/banner is clicked, also allows you to diguise affiliate links. Consists of 1 small PHP file and is very easy to use.