In this article we will talk about ONE-TO-MANY and MANY-TO-MANY relationships between tables.
This article describes how to debug procedures and functions with a help of Debugger for MySQL.
A view – is a database object based on a SELECT query that has tables or other views specified inside it. In other words, this is a named query that is stored in a database as a separate object. Unlike a table, a view is not a data storage.
When referring to a view, we just receive data that is returned by the internal SELECT query.
The DELIMITER command is used to change the standard delimiter of MySQL commands. The standard command delimiter is the ';' character that defines the end of the query.
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.
Creating a backup:
mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql
Creating a database structure without data:
mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql