PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
This userid value might not be the same as the user name of your MySQL account. Log in to your server with the SSH session you just created. Create a new file in Windows and link to MySQL using the ODBC driver the same way you normally do, except ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
If you have set a password for the root account, deleted the anonymous account, or created a new user account, then to connect to the MySQL server you must use the appropriate -u and -p options with the commands shown previously. (Be sure that an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Create_options shows the ENCRYPTION option specified when creating or altering a file-per-table tablespace. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. Create_options shows the row format that was specified in the CREATE TABLE ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When the body of a view requires row-based replication, the statement creating the view also uses it. For example, this occurs when the statement creating a view uses the UUID() function. (Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by means of a ...Stored procedures that take no arguments can be invoked without ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The following list briefly describes the items typically found in the data directory, with cross references for additional information: Data directory ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
Section 23.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. You may also find the MySQL User Forums to be helpful. The MySQL Event Scheduler manages the scheduling and execution of events, ...