I am creating a table and would like to use auto increment, but I would like one column to increment in only odd numbers 1,3,5... and another column of the same table to increment in even numbers 2,4,6...
Is it possible to do this?
Not using an AUTO_INCREMENT column, if that's what you're thinking of using.
Thanks, KB
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]