MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1811 to 1820 of 1826 total results

https://dev.mysql.com/doc/refman/5.7/en/drop-trigger.html

Use IF EXISTS to prevent an error from occurring for a trigger that does not exist. DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP ...

8.15.9 The end_markers_in_json System Variable

https://dev.mysql.com/doc/refman/5.7/en/end-markers-in-json-system-variable.html

Note If end_markers_in_json is enabled, the repetition of the key means the result is not a valid JSON document, and causes JSON parsers to throw an error. When reading a very large JSON document, it can be difficult to pair its closing bracket and ...

12.9.9 MeCab Full-Text Parser Plugin

https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html

The loose prefix allows you restart MySQL without encountering an error due to an unrecognized variable. The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a ...

14.6.6 Redo Log

https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log.html

The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API ...

12.17.2 Functions That Create JSON Values

https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html

mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...

21.6.11 NDB Cluster Disk Data Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data.html

It is possible to store the nonindexed columns of NDB tables on disk, rather than in RAM. As part of implementing NDB Cluster Disk Data work, a number of improvements were made in NDB Cluster for the efficient handling of very large amounts ...

21.3.7.2 Upgrading and Downgrading NDB 7.6

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-upgrade-downgrade-7-6.html

If such a node file system exists, but does not contain the Sysfile, and if any data nodes are restarted without the --initial option, NDB causes the restart to fail with an appropriate error message. This section provides information about ...

7.4.5.5 Using mysqldump to Test for Upgrade Incompatibilities

https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html

Look for warnings or errors while the dump file is being processed. When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production version. Then you can dump the database and database object ...

22.3.5 Obtaining Information About Partitions

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

2.12.3 Problems Using the Perl DBI/DBD Interface

https://dev.mysql.com/doc/refman/5.7/en/perl-support-problems.html

If you get the following errors from DBD::mysql, you are probably using gcc (or using an old binary compiled with gcc): /usr/bin/perl: can't resolve symbol '__moddi3' /usr/bin/perl: can't resolve symbol '__divdi3' Add -L/usr/lib/gcc-lib/... If Perl ...

Displaying 1811 to 1820 of 1826 total results