Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-upgrade.html
You can create the connection beforehand, or specify it as arguments to the function. The utility always creates a new session to connect to the server, so the MySQL Shell global session is not affected. More information: ... The ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. --check-only-changed, -C Command-Line Format --check-only-changed Check only tables that have changed since ...This is the default operation if you specify no option that selects an operation type ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. Only undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped. Similar to the system tablespace, ...The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html
Model Table Defaults Default Storage Engine: Tables created in MySQL Workbench are defined using this default storage engine. Figure 3.12 Preferences: Modeling: Defaults The following tables show the object names and their default values. Figure ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-scanning-basic.html
This example makes use of the following classes and methods: Ndb_cluster_connection: connect() wait_until_ready() Ndb: init() getDictionary() startTransaction() closeTransaction() NdbTransaction: getNdbScanOperation() execute() NdbOperation: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
For example: mysql> SELECT COLUMN_NAME, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 'airline_info' AND COLUMN_COMMENT LIKE '%ENCODING%'; +-------------+------------------------------+ | COLUMN_NAME | COLUMN_COMMENT | ...The ... This topic describes how to encode string columns to improve the performance of queries that access ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; INTO var_list can also be used with a TABLE statement, subject to these restrictions: The number of variables must match the number of columns in the table. If the table contains more than one row, ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json-run.html
If you specify none of the collection, table, or tableColumn options, the utility defaults to using or creating a target collection with the name of the supplied import file (without the file extension). tableColumn: "column_name" The name of the ...
https://dev.mysql.com/doc/workbench/en/wb-documenting-sakila.html
Rather than reading through table definition statements, a quick glance at an EER diagram indicates how tables are related. You can also see how tables are related; what the foreign keys are and what the nature of the relationship is. A PNG File of ... This chapter demonstrates the capabilities of MySQL Workbench as a documentation tool by using the sakila database, which is a database sample provided by ...