Search Results
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
Account management statements: CREATE, ALTER, DROP, and, if applicable, RENAME statements for users and roles, as well as GRANT and REVOKE statements. Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, ...An ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
For NDB: The name of an undo log file created by CREATE LOGFILE GROUP or ALTER LOGFILE GROUP, or of a data file created by CREATE TABLESPACE or ALTER TABLESPACE. This means, for example, that the name of a data file created with ALTER TABLESPACE ts ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Renaming an index ALTER TABLE tbl_name RENAME INDEX old_index_name TO new_index_name, ALGORITHM=INPLACE, LOCK=NONE; Adding a FULLTEXT index CREATE FULLTEXT INDEX name ON table(column); Adding the first FULLTEXT index rebuilds the table if there is ...The CREATE INDEX statement only finishes after all transactions that are accessing the table are completed, so that the initial state of the index reflects the most recent contents of the ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl.html
Create a test user account to use in this tutorial and set the account to require SSL. Using the MySQL Command-Line Client, connect as root and create the user sslclient (with test as the account password). Then, grant all privileges to the new user ... In this tutorial you will learn how you can use MySQL Connector/NET to connect to a MySQL server configured to use ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-macos.html
To configure a DSN on macOS, you can either use the command-line utility (myodbc-installer), edit the odbc.ini file within the Library/ODBC directory of the user, or use the ODBC Administrator GUI. Note The ODBC Administrator is included in OS X ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl.html
Create a test user account to use in this tutorial and set the account to require SSL. Using the MySQL Command-Line Client, connect as root and create the user sslclient (with test as the account password). Then, grant all privileges to the new user ... In this tutorial you will learn how you can use MySQL Connector/NET to connect to a MySQL server configured to use ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-macos.html
To configure a DSN on macOS, you can either use the command-line utility (myodbc-installer), edit the odbc.ini file within the Library/ODBC directory of the user, or use the ODBC Administrator GUI. Note The ODBC Administrator is included in OS X ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
This part would look different if the user had defined a primary key during the CREATE TABLE statement. Walking Through The Server Code: /sql/mysqld.cc int main(int argc, char **argv) { _cust_check_startup(); (void) thr_setconcurrency(concurrency); ... And now we're going to walk through something harder, namely the ...
A Quick Guide to Using the MySQL SLES Repository :: A Quick Guide to Using the MySQL SLES Repository
https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/index.html
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users. A password for the superuser is set and stored in the error log file. GOVERNMENT END USERS: Oracle programs (including any operating ... Abstract This is a quick guide for using the MySQL SLES repository to install and upgrade MySQL on SUSE Linux Enterprise Server ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-logs.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_logs( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36), IN 'newer_than_log_time' TIMESTAMP(6)); Following are app_task_logs ... The app_task_logs routine returns a list of logs associated with an application-level ...