Creating key values mysql

Question

I have worked with databases before where the key attributes for entities looked like

83NG92R8B202NG

I am trying to build a db myself and was wondering if there was a sql command that automatically assigned a key to an added tuple or I had to create some sort of random attribute algorithm myself.

Are you referring to a uniqueidentifier datatype? If so it is only hex digits... — apomene, May 14 '14 at 20:08

score 0 · Answer 1 · edited May 23 '17 at 12:05

0

Why not use a UUID? More information in mysql docs:

http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_uuid

If that doesn't fit your needs, take a look at this topic:

Generating a random & unique 8 character string using MySQL

edited May 23 '17 at 12:05

Community

1
1

answered May 14 '14 at 20:09

DaanCelie

163
1
3
8

Creating key values mysql

1 Answers1