Search Results
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) NOT NULL AUTO_INCREMENT, `c2` int(11) DEFAULT NULL, `c3` int(11) DEFAULT NULL, PRIMARY KEY (`c1`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 ... MySQL NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
row *************************** Table: t3 Create Table: CREATE TABLE `t3` ( `i1` int(11) DEFAULT NULL, `i2` int(11) DEFAULT NULL, CONSTRAINT `t3_chk_1` CHECK ((`i1` > 0)), CONSTRAINT `t3_chk_2` CHECK ((`i2` < 0)) ) ENGINE=InnoDB DEFAULT ... RENAME ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-upgrade.html
More information: https://dev.mysql.com/doc/refman/en/keywords.html dbtest.System - Table name dbtest.System.JSON_TABLE - Column name dbtest.System.cube - Column name 3) Usage of utf8mb3 charset Warning: The following objects use the utf8mb3 ... The ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-session.html
Since Version 3.0.13 customCharsetMapping A comma-delimited list of custom "charset:java encoding" pairs. sessionVariables A comma or semicolon separated list of "name=value" pairs to be sent as "SET [SESSION] ..." to the server when the driver ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
CharacterSet , Character Set , CharSet Specifies the character set that should be used to encode all queries sent to the server. This chapter describes the full set of MySQL Connector/NET 8.0 connection options. The protocol you use to make a ...
https://dev.mysql.com/doc/connectors/en/connector-net-connections-errors.html
You can specify the character set as part of the connection string, for example: MySqlConnection myConnection = new MySqlConnection("server=127.0.0.1;uid=root;" + "pwd=12345;database=test;Charset=latin1"); . Because connecting to an external server ...