MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 41 to 50 of 57 total results

https://dev.mysql.com/doc/refman/9.7/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 ...

13.6 Data Type Default Values

https://dev.mysql.com/doc/refman/9.7/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.7 MySQL Standards Compliance

https://dev.mysql.com/doc/refman/9.7/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 ...

15.1.11.1 ALTER TABLE Partition Operations

https://dev.mysql.com/doc/refman/9.7/en/alter-table-partition-operations.html

Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...

5.3.4.2 Selecting Particular Rows

https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html

The maximum and default value of rpl_stop_replica_timeout is 31536000 seconds (1 year). This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers ...

B.3.3.3 What to Do If MySQL Keeps Crashing

https://dev.mysql.com/doc/refman/9.7/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/9.7/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.15 CREATE EVENT Statement

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

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

Displaying 41 to 50 of 57 total results