PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
By default, tables are created in the default database, using the InnoDB storage engine. An error occurs if the table exists, if there is no default database, or if the database does not exist. This works regardless of whether there is a default ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Beginning with MySQL 8.0.34, this function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. --database=dbname, -d Command-Line Format --database=name Type String Default Value TEST_DB Name ...ndb_move_data options source target Options that can be used with ndb_move_data are shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Data Dictionary Changes caching_sha2_password as the Preferred Authentication Plugin Configuration Changes Server Changes InnoDB Changes SQL Changes Changed Server Defaults Valid Performance Regressions Data Dictionary Changes MySQL Server 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html
MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. To add, access, and process data stored in a computer database, you need a database management system such as MySQL ...The MySQL website (http://www.mysql.com/) provides the latest information about MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
It can be used to add a new data file to, or to drop a data file from an NDB tablespace. Using DROP DATAFILE with ALTER TABLESPACE drops the data file 'file_name' from an NDB tablespace. You cannot drop a data file from a tablespace which is in use ...It can also be used to rename an NDB Cluster Disk Data tablespace, rename an InnoDB general tablespace, encrypt an InnoDB general tablespace, or mark an InnoDB undo tablespace as active or ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, modifying, or dropping authentication methods for existing accounts. This can be achieved by dropping and recreating ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. You must specify the schema name if the ...