Unique Snippets

04 December, 2018   

PHP Code to create Unique AlphaNumeric

The Gmail Bookmarklet will add a unique string to the email signature to prevent Gmail from trimming the content.

10 September, 2011   

Example code showing how to add a primary constraint. This Oracle constraint is used to identify the primary key for a table. A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key. This...

30 September, 2012   

This query will show you how to select only distinct (unique) entries from a database

19 May, 2012   

Example code to load CSV back into mySQL

08 November, 2012   

This is a pretty rudimentary way to keep track of unique hits, but It works.

13 October, 2013   

To create 'examples' database on your MySQL server you should run the following script

29 March, 2015   

When creating an index, the default method Oracle uses to sort the index is in ascending order (SORT). However, if the rows are already stored in the database in ascending order you can use the NOSORT clause to skip the sorting process. If neither SORT or NOSORT is provided, Oracle will use SORT as the clause.

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...

19 October, 2014   

Creates a picture based on your IP address.

30 August, 2011   

This snippet to show how to use the Last-Modified and the ETag header to optimize the caching of a website. If used correctly this will speed up your page loads.