You can use an AUTO_INCREMENT field to generate a numeric value that will be
unique for each record. You will need to use an external process to generate
an alphanumeric key though.
-----Original Message-----
From: A Z
To: [EMAIL PROTECTED]
Sent: 6/16/04 6:27 AM
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
