Search Results
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-comments.html
Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as well. MySQL also support extensions to this syntax that enable MySQL-specific SQL to be embedded in the comment; see Section 11.7, ...In ...
https://dev.mysql.com/doc/refman/8.4/en/charset-we-sets.html
ascii (US ASCII) collations: ascii_bin ascii_general_ci (default) cp850 (DOS West European) collations: cp850_bin cp850_general_ci (default) dec8 (DEC Western European) collations: dec8_bin dec8_swedish_ci (default) The dec character set is ...
https://dev.mysql.com/doc/refman/8.4/en/checking-rpm-signature.html
To import the MySQL public key into the RPM keyring, first obtain the key, then use rpm --import to import the key. For example: $> gpg --export -a a8d3785c > a8d3785c.asc $> rpm --import a8d3785c.asc Alternatively, rpm also supports loading the key ...RPM 4.1 no longer uses your personal GPG keyring (or GPG ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
If ENGINE is not set, MySQL tries to use the engine specified by the default_storage_engine server system variable. REDO_BUFFER_SIZE, NODEGROUP, WAIT, and COMMENT are parsed but ignored, and so have no effect in MySQL 8.4. CREATE LOGFILE GROUP ...
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
MySQL provides functions for doing date arithmetic, so this is not difficult. Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
MySQL permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision. (This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Any TIMESTAMP or DATETIME ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
When the Event Scheduler is ON, the event scheduler thread is listed in the output of SHOW PROCESSLIST as a daemon process, and its state is represented as shown here: mysql> SHOW PROCESSLIST\G *************************** 1. Starting the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
The mysqladmin utility provides a command-line interface to some flush operations, using commands such as flush-logs, flush-privileges, flush-status, and flush-tables. This enables the flush operations to be performed without having to connect to ...