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/compiling-for-debugging.html
When you configure MySQL for debugging you automatically enable a lot of extra safety check functions that monitor the health of mysqld. If you have some very specific problem, you can always try to debug MySQL. To do this you must configure MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/connection-compression-control.html
For programs that use the MySQL C API, enabling the MYSQL_OPT_COMPRESS option for the mysql_options() function specifies use of compression for the connection to the server. Connections to the server can use compression on the traffic between ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-primary-key.html
You can get information about the number of rows actually inserted or updated with the mysql_info() C API function. Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
See Section 12.19.1, “Aggregate Function Descriptions” for information about COUNT(expr) behavior and related optimizations. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
SELECT, make sure to alias any function calls or expressions in the query. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
Within a trigger body, the CURRENT_USER function returns the account used to check privileges at trigger activation time. CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
MySQL provides functions for doing date arithmetic, so this is not difficult. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
When the server operates in bootstrap mode, some functionality is unavailable that limits the statements permitted in the file. After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For ...