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/create-table-secondary-indexes.html
This means that any NDB table having one or more JSON columns must have a primary key, else it cannot be recorded in the binary log. A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
With REPLACE, new rows replace rows that have the same unique key value. If you want to have indexes in the created table, you should specify these before the SELECT statement: mysql> CREATE TABLE bar (UNIQUE (n)) SELECT n FROM foo; For CREATE TABLE ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because ...
https://dev.mysql.com/doc/refman/8.0/en/custom-benchmarks.html
We have had many customers who contact us when they have a (tested) system in production and have encountered load problems. Benchmark your application and database to find out where the bottlenecks are. After fixing one bottleneck (or by replacing ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 8.0, enabling innodb_read_only prevents these operations for all storage ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
This means you should not use strings that have fewer than 6 characters. Here D represents days and can have a value from 0 to 34. The value inserted must not have a zero for the month part, the day part, or both parts. Standard SQL and ODBC Date ...
https://dev.mysql.com/doc/refman/8.0/en/date-calculations.html
What if you want to know which animals have birthdays next month? For this type of calculation, year and day are irrelevant; you simply want to extract the month part of the birth column. You can write the query so that it works no matter what the ... MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
The [AS] tbl_name clause is mandatory because every table in a FROM clause must have a name. For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an ...
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. As of MySQL 8.0.16, users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. Users who have the DROP ROLE ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
If you have fixed-length columns that you access or change frequently in a table that also contains some variable-length columns, it might be a good idea to move the variable-length columns to other tables just to avoid fragmentation. Dynamic-format ... Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table ...