PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
Any client can examine the value of lc_time_names or set its SESSION value to affect the locale for its own connection. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names value does not ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. This means that treatment of NULL varies between partitioning of different ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
A “system constant” (the string returned by functions such as USER() or VERSION()) has a coercibility of 3. For example, the following statement does not return an error: SELECT CONCAT(utf8_column, latin1_column) FROM t1; It returns a result ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be possible. Negative values for offset can thus prove useful ...Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement is ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-server-clients.html
"mysql_read_default_file=/usr/local/mysql/data/my.cnf"; $dbh = DBI->connect($dsn, $user, $password); See Section 27.9, “MySQL Perl API”. On Unix, set the MYSQL_UNIX_PORT and MYSQL_TCP_PORT environment variables to point to the Unix socket file ...For TCP/IP connections, you may also need to specify --host and --port ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
The same is true for other CREATE TABLE options such as CHARSET. Retrained attributes are NULL (or NOT NULL) and, for those columns that have them, CHARACTER SET, COLLATION, COMMENT, and the DEFAULT clause. You can create one table from another by ...The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax ...
https://dev.mysql.com/doc/refman/5.7/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. If you have a “phantom” problem (one that you cannot duplicate at will), use ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. Note Statements that update the information in the mysql system database, such as GRANT, REVOKE and the manipulation of triggers, ...
https://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html
Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images ...
https://dev.mysql.com/doc/refman/5.7/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.