Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. If an account is to be permitted to manipulate secondary passwords for all accounts, it requires the CREATE USER privilege ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
For non-language-specific collations, characters in contraction sequences are treated as separate characters. For example, utf8mb4_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8mb4 collations. Miscellaneous Information The xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
To search the title or body separately, you would create separate FULLTEXT indexes for each column. The MySQL FULLTEXT implementation regards any sequence of true word characters (letters, digits, and underscores) as a word. That sequence may also ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/connectors/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-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/refman/8.4/en/change-replication-source-to.html
When using a multithreaded replica (replica_parallel_workers > 0), stopping the replica can cause gaps in the sequence of transactions that have been executed from the relay log, regardless of whether the replica was stopped intentionally or ...] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
To create or modify a login path file, use the mysql_config_editor utility. The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. The INSERT and CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Consider these statements that create a small data set that shows, for each employee in a company, the employee name and ID number, and the ID of the employee's manager. CTEs are similar to tables created with CREATE [TEMPORARY] TABLE but need not ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
The connection errors are, by default, propagated to the client, which has to handle them by, for example, recreating the working objects (Statement, ResultSet, etc.) and restarting the processes. A failover happens when connection-related errors ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-executemany.html
Syntax: cursor.executemany(operation, seq_of_params) This method prepares a database operation (query or command) and executes it against all parameter sequences or mappings found in the sequence seq_of_params. In most cases, the executemany() ...