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/triggers.html
Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update. For example, you can have a trigger activate before each row that is inserted into a table or after each ... A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the ...
https://dev.mysql.com/doc/refman/5.7/en/two-digit-years.html
Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR results in 0000 rather than 2000. Date values with ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/5.7-datadir & Reset the root password: $> mysql -u root -p Enter password: **** <- enter temporary root password mysql> ALTER USER USER() IDENTIFIED BY 'your new password'; Load the previously ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
An administrative or management application that communicates with the servers and organizes them into high-availability groups. (Version Tokens uses the locking service routines built into the server, not the locking service function interface, so ... Before using Version Tokens, install it according to the instructions provided at Section 5.5.5.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
For TEMPTABLE, the results from the view are retrieved into a temporary table, which then is used to execute the statement. As mentioned earlier, MERGE is handled by merging corresponding parts of a view definition into the statement that refers to ... The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-crashing.html
This can normally be checked by pressing the Caps Lock key. If the Caps Lock light does not change, you have to replace your keyboard. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html
The standard binary distribution (packaged as a compressed file) contains all of the necessary files that you unpack into your chosen location. There is usually a system built into the virus-scanning software to enable specific directories to be ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/5.7/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...