PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
For strings, MySQL stores either the empty string or as much of the string as can be stored in the column. If you try to store a string that does not start with a number into a numeric column, MySQL Server stores 0. Invalid values for ENUM and SET ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Explicit Default Handling Implicit Default Handling Explicit Default Handling A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. In the definition of an integer column, it is an alias for NOT NULL ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Character Set Considerations The definition for character columns ...Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is updated. The ON DUPLICATE KEY UPDATE clause can contain multiple ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
It is also possible to specify whether an individual column is stored on disk or in memory by using a STORAGE clause as part of the column's definition in a CREATE TABLE or ALTER TABLE statement. STORAGE DISK causes the column to be stored on disk, ... NDB Cluster Disk Data storage is implemented using a number of Disk Data ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
row *************************** EVENT_NAME: memory/sql/TABLE COUNT_ALLOC: 1381 COUNT_FREE: 924 SUM_NUMBER_OF_BYTES_ALLOC: 2059873 SUM_NUMBER_OF_BYTES_FREE: 1407432 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 457 HIGH_COUNT_USED: 461 ...Operation counts ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_general_ci; Tables created in the database ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
As of MySQL 5.7.2, a warning is generated when the WITH CONSISTENT SNAPSHOT clause is ignored. Because of this, SHOW PROCESSLIST displays Rolling back in the State column for the session, not only for explicit rollbacks performed with the ROLLBACK ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM tbl_name WHERE date_column IS NULL This is needed to get some ODBC applications to work because ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
This event executes once—one hour following its creation—by running an SQL statement that increments the value of the myschema.mytable table's mycol column by 1. (However, a warning is generated in such cases.) The ON SCHEDULE clause determines ... 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] ...