Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE TestTable (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100)); The main method of the MySqlScript class is the Execute method.
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
After it has been created, there are three main methods of interest that you can call: ExecuteReader to query the database. Results are usually returned in a MySqlDataReader object, created by ExecuteReader. After the MySqlCommand object is created, ... When a connection has been established with the MySQL database, the next step enables you to perform database ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-groups.html
Table 20-1 Table 20-2 Table 20-3 Note: The OCI user account that registered for the MySQL HeatWave on AWS service is added to the OracleMySQLHeatwaveServiceAccountAdmin group when the service is provisioned. Any other users must be added to at least ... Groups and Permissions 20.1 Groups and Permissions MySQL HeatWave on AWS has three predefined ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Create and Set Up Streams The Events service requires an intermediary for events persistence and forwarding. Refer to the following resources from Oracle Cloud Infrastructure Documentation to learn more about streaming: Getting Started with ... As ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
It is possible using the NDB API to create tables independently of the MySQL server. However, it is usually not advisable to do so, since tables created in this fashion cannot be seen by the MySQL server. As with other database objects, Table object ... This section provides information about the Table class, which models a database table in the NDB ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
To create a user filter, you can either create a filter and save it by clicking Save as... Temporary Tables Temporary Tables Average: the average number of internal temporary tables created per occurrence of the statement. Temporary Tables Disk: the ... The Configuration View enables you to customize the data displayed on the Query Analyzer ...
https://dev.mysql.com/doc/connectors/en/connector-j-using-openID.html
Connector/J supports authentication for users created on a MySQL server using the authentication_openid_connect plugin. If no server user name is specified in the connection string or during the creation of the Connection object, the implementation ... OpenID Connect is an authentication protocol based on the OAuth 2.0 framework, providing a simplified and interoperable ways of authentication for enhanced ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-walkthrough.html
These instructions assume that you connect to system ALPHA from system BETA with a user name and password of myuser and mypassword. Use GRANT to set up an account with a user name of myuser that can connect from system BETA using a password of ... A ...