Mysql utf8_general_ci vs utf8_unicode_ci

MSQL, mysql, SQL

Why to use utf8_unicode_ci over utf8_general_ci, or simple why never not to use utf8_general_ci. Basically utf8_general_ci is a broken version of utf8_unicode_ci. It is slightly faster bit only a little bit and it can produce unexpected result while sorting or...

MySQL (MariaDB) – Appointment Database Schema

MSQL, SQL

In this blog post, you will be presented with MySQL booking database schema. You will also see examples of SQL calls to insert and validate a new booking request. At the end of this post, you will find the post on the logic behind this database and SQL queries...

SQL JOIN TUTORIAL

*, IT, MSQL, SQL

The above diagram can not fully represent JOIN charasteristicks due to its limitations. MySQL JOIN – (INNER JOIN) query result description characteristics:sequence – dos not matterchaining – dos not mater MySQL LEFT JOIN – (LEFT OUTER JOIN)...

Turn off / Disable modules in PrestaShop using SQL

MSQL, PrestaShop, SQL

Reading this article you will learn what are default prestashop module and how to disable non default modules or any module of your choice using simple SQL query. Default modules list installed with PrestaShop 1.7.7.5 SELECT GROUP_CONCAT(name ORDER BY id_module...