Search Results
https://dev.mysql.com/doc/refman/9.7/en/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log ...
https://dev.mysql.com/doc/refman/9.7/en/set-statement.html
Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET DEFAULT ROLE and SET ROLE set the default role and current role for user accounts. Descriptions for those forms that ...
https://dev.mysql.com/doc/refman/9.7/en/show-binlog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW BINLOG EVENTS. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not ...
https://dev.mysql.com/doc/refman/9.7/en/show-databases.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/9.7/en/show-relaylog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW RELAYLOG EVENTS. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-using.html
This section discusses the use of the API in executing and in obtaining and processing results from both simple SQL statements and prepared statements. SQL execution in JavaScript is available in stored procedures only, and not in stored functions.
https://dev.mysql.com/doc/refman/9.7/en/srjs-sql-api.html
This section provides reference information for the SQL and result set API supported by JavaScript stored routines in the MLE Component. The API supports the top-level objects listed here: Column: Result set column metadata. For information about ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-regressor.html
Regressor.score() Returns the score for the test data in the table and column indicated by the user, using a specified metric; a JavaScript wrapper for sys.ML_SCORE. Regressor Constructor Regressor.train() Regressor.fit() Regressor.predict() ...
https://dev.mysql.com/doc/refman/9.7/en/stop-group-replication.html
Any user credentials that you specified in the START GROUP_REPLICATION statement when starting Group Replication on this member are removed from memory, and must be supplied when you start Group Replication again. This statement requires the ...
https://dev.mysql.com/doc/refman/9.7/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and ...