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/mysql-cluster-programs-ndb-index-stat.html
--database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the database that contains the table being queried. --sys-drop Command-Line Format --sys-drop Drop all statistics ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Table creation and drop operations for any storage engine modify data dictionary tables in the mysql system database, but those tables use the InnoDB storage engine and cannot be modified when innodb_read_only is enabled. Some options, which you ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
Data definition language (DDL) statements that define or modify database objects. CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. SELECT.) Statements that implicitly use or modify tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is suitable for large, important databases that need to be recovered quickly when problems ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
The rows in these tables for a given account indicate the account privileges that apply on a global basis no matter what the default database is. For example, if the user table grants you the DELETE privilege, you can delete rows from any table in ... After the server accepts a connection, it enters Stage 2 of access ...
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/create-procedure.html
If you alter the database default character set or collation, stored routines that are to use the new database defaults must be dropped and recreated. By default, a stored routine is associated with the default database. To associate the routine ...