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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-conversion.html
To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the following way: date_col = CAST(datetime_col AS DATE) Conversion of TIME and DATETIME values to numeric form (for example, by adding +0) ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Thus, it is possible for this file not to be present on a MySQL server that is functioning in a completely normal manner. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...