BuySQL.com - Tools, software, tips of SQL

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.

Working with MySQL backups

Creating a backup:

mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql

mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql