Q:

Singleton function

Is it possible to create a singleton function inside of mysql?
BackStory:
Looking to recreate Oracle's "sequence" functionality inside of MySQL for a project so that all numbers returned are contiguous and unrepeated
TIA 

A:

You might be able to utilize the Distinct() operator.
select DISTINCT('your field') from `Your Table`

This can be better understood studying the examples from MYSQL's website at:
http://dev.mysql.com/doc/refman/5.1/en/distinct-optimization.html

