MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 391 to 400 of 405 total results

https://dev.mysql.com/doc/refman/8.0/en/year.html

For instructions on converting to 4-digit YEAR, see 2-Digit YEAR(2) Limitations and Migrating to 4-Digit YEAR, in MySQL 5.7 Reference Manual. The YEAR type is a 1-byte type used to represent year values. It can be declared as YEAR with an implicit ...

2.4 Installing MySQL on macOS

https://dev.mysql.com/doc/refman/8.0/en/macos-installation.html

To use this method, you need to open a Terminal window. You do not need administrator privileges using this method; you can install the MySQL server anywhere using this method. For more information on using this method, you can use the generic ...

B.3.4.4 Problems with Column Aliases

https://dev.mysql.com/doc/refman/8.0/en/problems-with-alias.html

This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. An alias can be used in a query select list to give a column a different name. In the select list of a query, a quoted column ...

B.3.2.12 Commands out of sync

https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html

If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you ...

2.5.6.3 Deploying MySQL on Windows and Other Non-Linux Platforms with Docker

https://dev.mysql.com/doc/refman/8.0/en/deploy-mysql-nonlinux-docker.html

This section discusses some known issues for the images when used on non-Linux platforms. This is because the way Docker for Windows handles file mounting does not allow a host file from being bind-mounted on the socket file. Warning The MySQL ...

B.3.3.4 How MySQL Handles a Full Disk

https://dev.mysql.com/doc/refman/8.0/en/full-disk.html

This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). If there is enough space, it continues as if nothing ...

1.2.3 History of MySQL

https://dev.mysql.com/doc/refman/8.0/en/history.html

This resulted in a new SQL interface to our database but with almost the same API interface as mSQL. This API was designed to enable third-party code that was written for use with mSQL to be ported easily for use with MySQL. We started out with the ...

B.3.6.1 Problems with ALTER TABLE

https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html

This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...

B.3.2 Common Errors When Using MySQL Programs

https://dev.mysql.com/doc/refman/8.0/en/common-errors.html

This section lists some errors that users frequently encounter when running MySQL programs. Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL ...

2.1.6 Compiler-Specific Build Characteristics

https://dev.mysql.com/doc/refman/8.0/en/compiler-characteristics.html

The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. In some cases, the compiler used to build MySQL affects the features available for use. icc (Intel C++ Compiler) ...

Displaying 391 to 400 of 405 total results