PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
It is always permissible to have spaces after a stored routine name, regardless of whether IGNORE_SPACE is enabled. This prohibition includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Corresponding columns in the foreign key and the referenced key must have similar data types. (A column cannot have a foreign key reference to itself.) In these cases, a “child table record” refers to a dependent record within the same table.
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
mysql> SELECT DAYNAME('2007-02-03'); -> 'Saturday' DAYOFMONTH(date) Returns the day of the month for date, in the range 1 to 31, or 0 for dates such as '0000-00-00' or '2008-00-00' that have a zero day part. mysql> SELECT MINUTE('2008-02-03 ... This ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
If you have not signed in to the OCR yet, click the Sign in button on the right of the page, and then enter your Oracle account credentials when prompted to. Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-security.html
Does MySQL have native support for SSL? Yes, the binaries have support for SSL connections between the client and server. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? Yes, the binaries have SSL ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html
Each system and Performance Schema table is accessible only by accounts that have the SELECT privilege for it. Each mysql system database table is accessible only by accounts that have the SELECT privilege for it. When enabled, the firewall bases ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
The requirement that function calls be written with no whitespace between the name and the parenthesis applies only to the built-in functions that have special considerations. This occurs even when the function name is used in nonexpression context: ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
Caution Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
These rows have the country and products columns set to NULL. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
Specifically, replicated databases have to deal with the fact that they require maintenance and administration of several servers instead of just one. Moreover, as servers are cooperating together to create the group several other classic ...The ...