You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@tomcat.apache.org by Andy Eastham <an...@peakdrive.com> on 2004/06/16 18:12:45 UTC

RE: How to (Unique value)?

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:xtcsuk@yahoo.co.uk]
> Sent: 16 June 2004 12:28
> To: mysql@lists.mysql.com
> 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/mysql?unsub=andy@peakdrive.com




---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org