What is "mysql"

Mysql is a relational database management system (RDBMS) that functions as a server, and provides multi-user access to a set of databases. Your source code is available under GNU General Public License.

Mysql offers a standard database connectivity driver, which can be used by various applications and tools, and is compliant with industry standards ODBC and JDBC.

Obsolecence of functions mysql_

PHP functions that start with mysql were considered obsolete from PHP 5.5.0. If you are in a position to do so, please update your code to use the extensions Mysqli or PDO in his stead.

Example

SELECT * FROM users ORDER BY Name

Common mistakes

Mysql like other banks always returns an error code known as sql state and a message that helps describe the problem and in which category it fits, the most common errors are:

1054 - Unknown column 'x' in 'field list' => indicates that the field does not exist in this table or the name was entered wrong.

1064 - You have an error in your SQL syntax => indicates a syntax error in the SQL statement.

1062 - Duplicate entry '%' for key %d => indicates that there is a duplicate value for that column.

1146 - Table 'x' doesn’t exist => indicates that the table does not exist in this database or the name was misspelled.

Resources