MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 351 to 359 of 359 total results

« Previous
34
35
36
Next »

https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html

For more information, see Chapter 18, Alternative Storage Engines, and Section 10.4.7, “Limits on Table Column Count and Row Size”. You can increase the size of an NDB blob column's blob part to the maximum of 13948 using NDB_COLUMN in a column ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...

Chapter 27 Stored Objects

https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html

The following sections provide additional information about SQL syntax for statements related to these objects, and about object processing: For each object type, there are CREATE, ALTER, and DROP statements that control which objects exist and how ... This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html

In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character ...

30.4.4.14 The ps_setup_save() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html

This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...

10.11.2 Table Locking Issues

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

InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...

B.3.3.5 Where MySQL Stores Temporary Files

https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html

The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE statements. On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary files.

10.3.14 Indexed Lookups from TIMESTAMP Columns

https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html

Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...

8.2.1 Account User Names and Passwords

https://dev.mysql.com/doc/refman/8.0/en/user-names.html

You should never alter the structure of tables in the mysql database in any manner whatsoever except by means of the procedure that is described in Chapter 3, Upgrading MySQL. Alternatively, the password can be specified on the command line: $> ...

27.5.2 View Processing Algorithms

https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html

The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace ...