MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 41 to 50 of 56 total results

https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html

MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. MySQL, the most popular Open Source SQL database ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/8.0/en/features.html

Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...

13.6 Data Type Default Values

https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html

Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...

1.6 MySQL Standards Compliance

https://dev.mysql.com/doc/refman/8.0/en/compatibility.html

“SQL:1999”, “SQL:2003”, “SQL:2008”, and “SQL:2011” refer to the versions of the standard released in the corresponding years, with the last being the most recent version. This section describes how MySQL relates to the ANSI/ISO SQL ...

5.3.4.2 Selecting Particular Rows

https://dev.mysql.com/doc/refman/8.0/en/selecting-rows.html

As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...

5.3.4.1 Selecting All Data

https://dev.mysql.com/doc/refman/8.0/en/selecting-all.html

Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Fix only the erroneous record with an UPDATE ...

B.3.3.3 What to Do If MySQL Keeps Crashing

https://dev.mysql.com/doc/refman/8.0/en/crashing.html

The current dynamic row code has been in use for several years with very few problems, but dynamic-length rows are by nature more prone to errors, so it may be a good idea to try this strategy to see whether it helps. Each MySQL version is tested ...

26.3 Partition Management

https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html

There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...

15.1.13 CREATE EVENT Statement

https://dev.mysql.com/doc/refman/8.0/en/create-event.html

CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The event does ...

26.3.5 Obtaining Information About Partitions

https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html

This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...

Displaying 41 to 50 of 56 total results