Skip to content

Instantly share code, notes, and snippets.

@NimzyMaina

NimzyMaina/random-data.sql

Created October 31, 2017 12:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save NimzyMaina/9c4322011fd658a55c91c5168a8e9a7b to your computer and use it in GitHub Desktop.
Save NimzyMaina/9c4322011fd658a55c91c5168a8e9a7b to your computer and use it in GitHub Desktop.
Download ZIP
Updating MySQL tables with random data
Raw
random-data.sql
UPDATE backup
SET agent_code = ELT(1 + FLOOR(RAND()*8),
'73572689',
'82778947',
'65857689',
'93335986',
'39894552',
'25344286',
'35939776',
'79822264');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment