PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/update.html
If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented. The ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
row *************************** PLUGIN_NAME: ndbcluster PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 50729.0 PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL PLUGIN_AUTHOR: MySQL AB PLUGIN_DESCRIPTION: ... This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Examples: For conversion of a “zero” date string to a date, CONVERT() and CAST() return NULL and produce a warning when the NO_ZERO_DATE SQL mode is enabled. Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Each of those functions, if successful, returns a binary string indicating what action occurred. Version Tokens treats token names and values as binary strings, so comparisons are case-sensitive. Otherwise, an error occurs: mysql> SELECT ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. This occurs, for example, if a function does not support a specified algorithm, a key length is too short or long, or a ... MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', and so forth. 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, ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) To change the storage type of an ...For ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional dependence would apply. As with the previous example, a UNIQUE key over NOT NULL columns could be used instead of a primary key. If in the join ...