How to (Unique value)?

2004-06-16 Thread A Z
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

RE: How to (Unique value)?

2004-06-16 Thread Victor Pendleton
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