IMELGRAT.ME

Resources for Developers

Tag

query

Using Random Numbers in MySQL – A few use cases

Share it!

Share it!Although you might not expect it, random numbers are used in databases quite often, especially when generating dummy data, providing randomized lists of products, to name just a couple. For instance, let’s say you have a table named “productData”… Continue Reading →


Share it!

Composite indexes – When should you use them in MySQL?

Share it!

Share it!What are composite indexes? Database engines (e.g. MySQL, PostgreSQL, etc.) can create composite indexes on table data. That is, indexes on multiple columns at once, instead of indexing a single column. For instance, MySQL allows indexes of up to… Continue Reading →


Share it!

© 2019 IMELGRAT.ME

Theme by Iván MelgratiTop ↑