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/function-loading.html
For this reason, DROP FUNCTION requires the DELETE privilege for the mysql system database. For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. Uninstalling Loadable Functions To remove a loadable function, ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
If the source database contains existing data it is necessary to copy this data to each replica. There are different ways to dump the data from the source database. To select the appropriate method of dumping the database, choose between these ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
When a database is dropped, all stored routines associated with it are dropped as well. Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”), and ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
Note If the --auto-generate-sql option is also given, mysqlslap drops the schema at the end of the test run. --no-drop Command-Line Format --no-drop Type Boolean Default Value FALSE Prevent mysqlslap from dropping any schema it creates during the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. However, it does need to access the MySQL server on which the database to ...Unlike the other utilities discussed in this section, it does not require access to an NDB Cluster (in fact, there is no reason for it to do ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 MODIFY COLUMN c2 TINYINT GENERATED ALWAYS AS (c1 + 5) STORED; Generated columns can be renamed or dropped, if no other column refers to them. CREATE TABLE t1 (c1 ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-installation.html
To remove them, use the UNINSTALL PLUGIN and DROP FUNCTION statements: UNINSTALL PLUGIN version_tokens; DROP FUNCTION version_tokens_set; DROP FUNCTION version_tokens_show; DROP FUNCTION version_tokens_edit; DROP FUNCTION version_tokens_delete; DROP ...To avoid this overhead, do not install it unless you plan to use ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
Note If you use ALTER DATABASE to change the database default character set or collation, existing stored routines in the database that use those defaults must be dropped and recreated so that they use the new defaults. If applications require data ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
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 ...