Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data-adapter.html
The application was built using the Microsoft Visual Studio to place and create the user interface controls, but the main code that uses the key classes described previously is shown in the next code example, and is portable. It is also possible to ... Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly ...
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
Recommendation: It is either DROP or CREATE Schema Name Table Name Indexed Columns Reason: Reason for making the recommendation. Reasons for DROP include Unused Index and Duplicate Index, and reason for CREATE is Missing Index. Performance Impact: ... Running Autopilot Index Advisor 11.1 Running Autopilot Index Advisor To run Autopilot Index Advisor, the user must connect to the DB system and have the following MySQL privileges: The EXECUTE privilege on the sys ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
Definer The account of the user who created the event, in 'user_name'@'host_name' format. Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the table is created on the MySQL Database Service instance. (WL #14328, WL #14510, WL #14431, WL #14328, WL #14651) Auto Parallel Load The new MySQL HeatWave Auto Parallel ... Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides string column encoding and data placement key recommendations based on machine learning models, data analysis, and MySQL HeatWave query ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. Suppose that a customer table containing customer records has these columns: id: ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
Dropping a database does not remove any TEMPORARY tables that were created in that database. TEMPORARY tables are automatically removed when the session that created them ends. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all ...
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ n/a Created STZ n/a Last altered STZ n/a . To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. The session time ...Event Scheduler Time Representation Each session in MySQL has a session time zone ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
For example: It creates the configuration file (my.ini) that is used to configure the MySQL server. It can optionally create MySQL server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and ... MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation ...
https://dev.mysql.com/doc/refman/8.4/en/test-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). For example: $> mysql --user=testuser --password Enter password: ... MySQL ...