PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this case, i has no ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
LZ77 compression works by finding sequences of data that are repeated within the data to be compressed. If innodb_strict_mode is ON, MySQL checks the maximum row size during CREATE TABLE or CREATE INDEX. If you create a table when innodb_strict_mode ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
It is important to remember—regardless of the type of partitioning that you use—that partitions are always numbered automatically and in sequence when created, starting with 0. However, it is not difficult in MySQL to create partitioning schemes ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
A stored routine that uses the database defaults when the routine is created includes those defaults as part of its definition. See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
To create or modify a login path file, use the mysql_config_editor utility. The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. The INSERT and CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
Consider these statements that create a small data set that shows, for each employee in a company, the employee name and ID number, and the ID of the employee's manager. CTEs are similar to tables created with CREATE [TEMPORARY] TABLE but need not ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Can I run NDB Cluster nodes inside virtual machines (such as those created by VMWare, VirtualBox, Parallels, or Xen)? A.10.13. You must also remember to account for any column indexes as follows: Each primary key or hash index created for an ... In ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... To minimize the dependency of SQL code on the IGNORE_SPACE setting, use these ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...