Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
These mode values are permissible, in order of increasing strictness: DISABLED: Establish an unencrypted connection. This section describes options supported by most MySQL client programs that control how client programs establish connections to ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
You may optionally follow either or both of these with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
When setting EXTENT_SIZE or INITIAL_SIZE, you may optionally follow the number with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. The precise syntax and semantics depend on the storage engine used. MySQL NDB ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
The reason for this is that the anonymous-user account has a more specific Host column value than the 'finley'@'%' account and thus comes earlier in the user table sort order. To manage MySQL accounts, use the SQL statements intended for that ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
The ordering constraint also applies to the use of ALTER TABLE to reorder table columns. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01'); -> 3 mysql> SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01'); -> -1 mysql> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55'); -> 128885 Note The order of the date or ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME ...
https://dev.mysql.com/doc/refman/8.4/en/declare.html
The DECLARE statement is used to define various items local to a program: Local variables. END compound statement and must be at its start, before any other statements. Variable and condition declarations must appear before cursor or handler ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
Encryption algorithms must include security elements to resist many kinds of known attacks such as changing the order of encrypted messages or replaying data twice. With an unencrypted connection between the MySQL client and the server, someone ...