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 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.
DROP TABLE Product;DROP TABLE ProductCategory;DROP TABLE Category; CREATE TABLE Product ( productId INT NOT NULL PRIMARY KEY, name VARCHAR(40) NOT NULL, description VARCHAR(100) NULL, price DECIMAL(7,2), weight FLOAT(5,4) NULL); CREATE TABLE ProductCategory ( productID INT NOT NULL, categoryID INT NOT Read More …