Unique keys are generated by using the AUTO_INCREMENT attribute on an integer column.
http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html Andy > -----Original Message----- > From: A Z [mailto:[EMAIL PROTECTED] > Sent: 16 June 2004 12:28 > To: [EMAIL PROTECTED] > Subject: How to (Unique value)? > > > 4.0.14 > > Its rather a general SQL question, I'll ask it as I'm > using MySQL. > > An converted table has field of type VarChar(6), > containing alphanumeric chars. > Is it possible to run a query to generate a unique key > so this can be used for new record? > > regards > > > > > > > ___________________________________________________________ALL-NEW Yahoo! > Messenger - sooooo many all-new ways to express yourself > http://uk.messenger.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]