Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd

arekgotfryd/Generate random decimal numbers (2 places precision) between 5 and 10

Created October 23, 2018 20:16
Show Gist options
  • Save arekgotfryd/87672ce38dc1b386ca78c63b57cbc04e to your computer and use it in GitHub Desktop.
Save arekgotfryd/87672ce38dc1b386ca78c63b57cbc04e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Generate random decimal numbers (2 places precision) between 5 and 10
UPDATE online_bookstore.book SET unit_price = TRUNCATE(RAND()*(10-5)+5,2);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment