Describes a query that selects SUM or COUNT with specific WHERE condition.
Category: MySQL, Tips&Snippets
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.
Category: MySQL, Articles
Neor Profile SQL is a MySQL profiling tool for tracking the SQL queries.
Category: MySQL, Tools
How to get top 3 products and all others in a separate row.
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.
How to exit from stored procedure.