Skip to content

Instantly share code, notes, and snippets.

@antic183

antic183/mysql-random-character.sql

Created November 17, 2020 08:27
Show Gist options
  • Save antic183/daa81248294c02398e554d527fa6603b to your computer and use it in GitHub Desktop.
Save antic183/daa81248294c02398e554d527fa6603b to your computer and use it in GitHub Desktop.
Download ZIP
mysql, mariadb generate random character
Raw
mysql-random-character.sql
select elt(( FLOOR(1 + (RAND() * 26)) ),'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment