SQL example creating table with auto-increment.
...
There are four versions of UUIDs.
UUID1 uses MAC address and timestamp to generate effective uniqueness.
UUID3 and UUID 5 uses cryptographic hashing and application-provided text strings to generate UUID. (UUID 3 uses MD5 hashing, and UUID 5 uses SHA-1 hashing).
UUID4 uses pseudo-random number generators to generate UUID.
TICKET SERVER
MySQL’s Replace Into Statement can help to make MySQL auto-increment work across multiple databases, set up a dedicated database with a single table and a single record whose sole purpose is to provide unique and incremental ID.
REPLACE works exactly like INSERT, except if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new one row is inserted.
CREATE TABLE ID ( id bigint(20) unsigned NOT NULL auto_increment, stub char(1) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY stub (stub)) ENGINE=MyISAM