MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1811 to 1820 of 1865 total results

https://dev.mysql.com/doc/refman/8.0/en/platform-support.html

MySQL platform support evolves over time; please refer to https://www.mysql.com/support/supportedplatforms/database.html for the latest updates.

2.10.2 Installing ActiveState Perl on Windows

https://dev.mysql.com/doc/refman/8.0/en/activestate-perl.html

If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...

15.7.2.1 ALTER RESOURCE GROUP Statement

https://dev.mysql.com/doc/refman/8.0/en/alter-resource-group.html

The attributes for CPU affinity, priority, and whether the group is enabled can be modified with ALTER RESOURCE GROUP. These attributes are specified the same way as described for CREATE RESOURCE GROUP (see Section 15.7.2.2, “CREATE RESOURCE GROUP ... ALTER RESOURCE GROUP group_name [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE [FORCE]] vcpu_spec: {N | M - N} ALTER RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource ...

15.6.5.1 CASE Statement

https://dev.mysql.com/doc/refman/8.0/en/case.html

If no when_value or search_condition matches the value tested and the CASE statement contains no ELSE clause, a Case not found for CASE statement error results. CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN ...This ...

15.6.6.1 Cursor CLOSE Statement

https://dev.mysql.com/doc/refman/8.0/en/close.html

If not closed explicitly, a cursor is closed at the end of the BEGIN ...

15.6.8 Restrictions on Condition Handling

https://dev.mysql.com/doc/refman/8.0/en/condition-handling-restrictions.html

In MySQL, this is not guaranteed, so to get the main error, you cannot do this: GET DIAGNOSTICS CONDITION 1 @errno = MYSQL_ERRNO; Instead, do this: GET DIAGNOSTICS @cno = NUMBER; GET DIAGNOSTICS CONDITION @cno @errno = MYSQL_ERRNO; . In standard ...

15.6.7 Condition Handling

https://dev.mysql.com/doc/refman/8.0/en/condition-handling.html

Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing execution. Handlers can be defined for general conditions such as warnings or exceptions, or for specific ...

15.6.7.8 Condition Handling and OUT or INOUT Parameters

https://dev.mysql.com/doc/refman/8.0/en/conditions-and-parameters.html

If the exception is an error, the values of OUT and INOUT parameters are not propagated back to the caller. If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller.

8.2.8 Adding Accounts, Assigning Privileges, and Dropping Accounts

https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html

For any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. The next example creates three accounts and grants them access at lower levels; that is, to specific ... To ...GRANT and REVOKE assign privileges to and revoke privileges from ...

15.5.3 DEALLOCATE PREPARE Statement

https://dev.mysql.com/doc/refman/8.0/en/deallocate-prepare.html

{DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared statement name. Attempting to execute a prepared statement after deallocating it results ...

Displaying 1811 to 1820 of 1865 total results