Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-secure-installation.html
The --ssl-fips-mode option differs from other --ssl-xxx options in that it is not used to establish encrypted connections, but rather to affect which cryptographic operations to permit. This program enables you to improve the security of your MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-collections-operations.html
For example, to drop the flags collection from the current schema, issue: mysql-js> db.dropCollection("flags") The dropCollection() method is also used in MySQL Shell to drop a relational table from a schema. In MySQL Shell, you can create new ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-collections-operations.html
For example, to drop the flags collection from the current schema, issue: mysql-py> db.drop_collection("flags") The drop_collection() method is also used in MySQL Shell to drop a relational table from a schema. In MySQL Shell, you can create new ...
https://dev.mysql.com/doc/refman/8.4/en/mysql.html
When used interactively, query results are presented in an ASCII-table format. mysql is a simple SQL shell with input line editing capabilities. When used noninteractively (for example, as a filter), the result is presented in tab-separated format.
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-backup.html
If this causes a conflict with the ID of a replica server or another mysqlbinlog process, use --connection-server-id to specify an alternative server ID. If you use mysqlbinlog --raw to back up the files, the --result-file option produces output ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-server.html
There are performance and reliability considerations depending on the type of table (transactional or nontransactional) and whether you use replication. The following discussion covers these MySQL server configuration topics: Startup options that ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld.html
MySQL Server manages access to the MySQL data directory that contains databases and tables. mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. The data directory is also the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/8.4/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-functions.html
Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...