Tag Archives: MariaDB

Little MySQL optimization/weird behaviour

Here is another little weird behaviour about MySQL (5.5.46-0ubuntu0.14.04.2). Today i needed to make a query for searching a table with millions of rows for all rows between two dates. The query goes something like this: Running querys like this … Continue reading

Posted in Knowledge | Tagged , , , | Leave a comment

FU MySQL/MariaDB

I just spent an HOUR trying to find out why a stored procedure was returning NULL no matter what i did! Here is the procedure i was trying to create: Simple right? Can you spot the mistake? No? Well don’t … Continue reading

Posted in Knowledge | Tagged , , , , | Leave a comment