n-m

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 …

MySQL cheat sheet

When developing an internet site, you may often see developers making recurring mistakes when designing databases. Today I decided to publish own FAQ answers for working with MySQL.       Working with MySQL backups Creating a backup:

Creating a Read More …