Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those statements. Note A dump made using PowerShell on Windows with output ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. CREATE Enables use of statements that create new databases and tables. (The CREATE USER privilege also enables use of the CREATE ROLE statement.) See ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
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 (current) database name as a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Within a string, certain sequences have special meaning unless the NO_BACKSLASH_ESCAPES SQL mode is enabled. Each of these ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
Loadable Function Calling Sequences for Simple Functions This section describes the different interface functions that you must define to create a simple loadable function. Loadable Function Calling Sequences for Aggregate Functions This section ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support loadable functions. If binary logging is enabled, CREATE FUNCTION might ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
--innodb-status-file Command-Line Format --innodb-status-file[={OFF|ON}] Type Boolean Default Value OFF The --innodb-status-file startup option controls whether InnoDB creates a file named innodb_status.pid in the data directory and writes SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-reading.html
The result is a sequence of files that are subject to access using the log-reading functions: audit_log_read() reads events from the audit log or closes the reading process. To use the functions to read the audit log, follow these principles: Call ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...