Archive

Posts Tagged ‘unique’

URI vs URN vs URL

Mar 13th, 2010

Do you know what does URI, URL and URN means? I bet you will say that I know about URL but what about URI and URN! Here is a good description on Wikipedia and that is enough to understand these three:
URI tells a unique path to a resource on… READ MORE

MySQL: Remove Duplicate Rows/Records from Table

Jun 22nd, 2008

How to remove duplicate entries from a table? Here are few methods for deleting duplicate rows/records from a table in mysql. The same concept will work in other database table for example, Oracle, as well.
Methods of deleting duplicate records in a table:-
1. Alter table for adding unique index… READ MORE

Unique numerical ID for Order Number, Invoice, table index or other usage

Jul 8th, 2007

We use numerical identification for table’s primary key, unique key or index key. Unique Key also needed for Invoice number, shopping order number and so on.
In general field type Auto Increment is good for these cases. What if you don’t like it or you get requirement for different formatted… READ MORE

Unique Identification for file/ folder name, ID, table key, invoice/ order number

Jul 8th, 2007

We need create unique number/name/values for various reasons. We need to create files with unique names, unique folders names, and primary key in table, index key in table and invoice number, order no and so on.
Create file with unique file name
PHP function tempnam() (not tempname ())
Syntax: string… READ MORE