MySQL
MySQL: How to ‘SUM IF’ or ‘COUNT IF’
Blog
22 de Janeiro de 2021
MySQL: How to ‘SUM IF’ or ‘COUNT IF’
MySQL doesn't have those direct functions available, but it is possible to do it. Check out the solution!
MySQL: Counting and Filtering Child Elements
Blog
10 de Dezembro de 2020
MySQL: Counting and Filtering Child Elements
If you have a category table similar like the one below, and have the need to count the children elements,…
MySQL how to convert Time to Decimal or How to Average Time
Blog
19 de Julho de 2016
MySQL how to convert Time to Decimal or How to Average Time
Hi all, today I’ve came across with a problem that I wanted to average time, get the average from a…
MySQL: How to order VARCHAR as INT
Blog
17 de Fevereiro de 2015
MySQL: How to order VARCHAR as INT
Sometimes it is needed to order type fields VARCHAR as INT. If you order a VARCHAR type field, the result…