Describes a query that selects SUM or COUNT with specific WHERE condition.
How to know MySQL server version.
How to generate random char
In this article we will talk about ONE-TO-MANY and MANY-TO-MANY relationships between tables.
Neor Profile SQL is a MySQL profiling tool for tracking the SQL queries.
How to get top 3 products and all others in a separate row.
http://stackoverflow.com/questions/13305459/mysql-group-by-query-with-addtional-row/13305688#13305688 CREATE TABLE sales( id INT(11) PRIMARY KEY AUTO_INCREMENT, product_id INT(11), qty INT(11)); INSERT INTO sales VALUES (NULL, 1, 500), (NULL, 1, 300), (NULL, 1, 400), (NULL, 2, 1000), (NULL, 2, 500), (NULL, 3, 10), (NULL, 3, 20), (NULL, Read More …
How to edit values of SET data type
How to set AUTO_INCREMENT step
How to round TIME values to the nearest period – 10, 15, 20, 30 minutes.