On Duplicate Update Snippets


24 August, 2013   

MySQL code to find duplicate records in table

02 January, 2012   

The UPDATE statement is used to update existing records in a table

14 May, 2011   

This is a general code to use when updating an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match.

An example of finding duplicate values in a table column

29 July, 2013   

Update random dates in MYSQL table

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.

Example code to update or convert the field to UPPERCASE.

22 December, 2012   

How to update random dates in MYSQL table

28 November, 2013   

Edit database using vb + access

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.

11 July, 2013   

Help manage mysql database common task

MS SQL triggers for automatic Create and LastModified Dates

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.

How to dynamically update your Snippets

05 October, 2016   

This code accumulates 100 units of part number 9999 from various storage bins

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.

24 July, 2013   

An example of how to use the mysql_real_escape_string

23 November, 2013   

You can search and replace fields by below query in MySQL Database

29 December, 2012   

Example MySql code to append Data to Field in MySql