Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/9.7/en/year.html
The result of inserting a numeric 0 has a display value of 0000 and an internal value of 0000. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. In strict SQL mode, attempting to insert an invalid YEAR value ...
https://dev.mysql.com/doc/refman/9.7/en/table.html
With INTO to populate user variables, and with INTO OUTFILE or INTO DUMPFILE to write table data to a file. With INSERT and REPLACE statements, where you would otherwise use SELECT *. TABLE is a DML statement which returns rows and columns of the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
If no instructions have been defined, this method attempts to insert a single interpret_exit_ok() method call prior to finalization. NdbInterpretedCode::load_const_null() Description This method is used to load a NULL value into a register. This ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-lifecycle.html
MySQL appends a statement to the transaction to insert the GTID into the table. Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all transactions that were written into the previous binary log file into the ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/9.7/en/encryption-functions.html
For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text',UNHEX('F3229A0B371ED2D9441B830D21A390C3'))); A passphrase can be used to generate an AES key by hashing the passphrase. For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text', UNHEX(SHA2('My ...Storing the string also results in slower comparisons because of the larger values and the need to take character set collation rules into ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-boolean.html
The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. '+apple macintosh' Find rows that contain the word “apple”, but rank rows higher if they also contain “macintosh”. '+apple ... MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-search-mecab.html
The MeCab full-text parser plugin is a full-text parser plugin for Japanese that tokenizes a sequence of text into meaningful words. For example, MeCab tokenizes “データベース管理” (“Database Management”) into ... The built-in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
The server SQL mode can affect how an invalid JavaScript value is handled when attempting to insert it into an ENUM or SET column. When strict mode is in effect (the default), an invalid value throws an error; otherwise, an empty string is inserted, ... Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-full-text-plugins.html
The instructions use the source code in the plugin/fulltext directory of MySQL source distributions, so change location into that directory. That is, when the plugin parsing function is called, it should parse the input into words and invoke the ...