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/programs-overview.html
It is usually executed only once, when first installing MySQL on a system. mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...D is the number of digits to the right of the decimal point (the ...
https://dev.mysql.com/doc/refman/5.7/en/rename-user.html
Attempts to access such objects may produce an error if they execute in definer security context. An error occurs for old accounts that do not exist or new accounts that already exist. RENAME USER old_user TO new_user [, old_user TO new_user] ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. 17.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. mysql> START GROUP_REPLICATION; ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. To be safe, always use complete datetime, date, or time strings when doing ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/5.7/en/commands-out-of-sync.html
This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result(). It can also happen if you try to execute two queries that return data without calling mysql_use_result() or ... If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
If any tables named in the argument list do not exist, DROP TABLE behavior depends on whether the IF EXISTS clause is given: Without IF EXISTS, the statement drops all named tables that do exist, and returns an error indicating which nonexisting ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-plugin-specific.html
Return value: Returns 1 for success, or NULL and an error for failure. Return value: Returns 1 for success, or NULL and an error for failure. For each keyring plugin-specific function, this section describes its purpose, calling sequence, and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.