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 …
Category: Articles
Mysql how to use. Useful MySQL articles for self-education. Detailed descriptions of the features work with MySQL. Debugger practice and export/import data MySQl.
Debugging procedures and functions using myDebugger for MySQL
This article describes how to debug procedures and functions with a help of Debugger for MySQL.
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:
1 |
mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql |
Creating a Read More …