[ V ] Krishna Journey

My journey with full of smart work

Saturday, 25 July 2015

Create Alphanumeric key randomly in mysql

In mysql you can easily generate random alpha numeric Key like below one.

SELECT UPPER(LEFT(UUID(), 5)) NEW_ID;
Posted by Grandhi Vamsi Krishna at 8:34 pm
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2018 (1)
    • ►  March (1)
  • ►  2017 (2)
    • ►  May (1)
    • ►  January (1)
  • ►  2016 (65)
    • ►  December (1)
    • ►  November (4)
    • ►  October (1)
    • ►  September (2)
    • ►  August (3)
    • ►  July (5)
    • ►  June (4)
    • ►  May (4)
    • ►  April (4)
    • ►  March (27)
    • ►  February (9)
    • ►  January (1)
  • ▼  2015 (25)
    • ▼  July (2)
      • SQL JOINS
      • Create Alphanumeric key randomly in mysql
    • ►  June (1)
    • ►  April (3)
    • ►  March (8)
    • ►  February (1)
    • ►  January (10)
  • ►  2014 (64)
    • ►  December (22)
    • ►  November (21)
    • ►  October (1)
    • ►  September (3)
    • ►  August (4)
    • ►  June (9)
    • ►  May (4)

About Me

Grandhi Vamsi Krishna
View my complete profile
Picture Window theme. Powered by Blogger.