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/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. MySQL enables you to work both with transactional tables that permit rollback and with ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system database because it adds a row to the mysql.func system table to register the function. CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
The creating session can perform any operation on the table, such as DROP TABLE, INSERT, UPDATE, or SELECT. You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system database. CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
Indexes are good for retrieval, but slow down insert and update operations. Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
This makes TIMESTAMP useful for recording the timestamp of an INSERT or UPDATE operation. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
In particular, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and ...