PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE ... The ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
mysql_upgrade returns an error if a sys schema exists but has no version view, on the assumption that absence of this view indicates a user-created sys schema. Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Create_options shows the ENCRYPTION option specified when creating or altering a file-per-table tablespace. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. Create_options shows the row format that was specified in the CREATE TABLE ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. The number increases each time the server creates a new log file, thus creating an ordered series of files. The server ...It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates a table format file in the database directory. The setup for the source is: CREATE TABLE t1 (public_col_1, ..., public_col_N, secret_col_1, ..., secret_col_M) ENGINE=MyISAM; The setup for the ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Other Uses for Cast Operations The cast functions are useful for creating a column with a specific type in a CREATE TABLE ... SELECT statement: mysql> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE) AS c1; mysql> SHOW CREATE TABLE ... Table ...