PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
(Observe that it could have a match, were the operator a null-safe equals <=>). Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
If the FIELDS ESCAPED BY character is empty, no characters are escaped and NULL is output as NULL, not \N. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
For more information about how NDB stores columns of blob types, see String Type Storage Requirements. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_TABLE ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...