Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-size.html
Row Format InnoDB tables are created using the DYNAMIC row format by default. To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. To ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this case, i has no ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-requirements.html
Review the following requirements and restrictions for table annotations and DML operations on JSON duality views. Requirements and Restrictions for Insert Annotations The root object and sub-objects of a document must have the INSERT annotation.
https://dev.mysql.com/doc/refman/9.7/en/keyring-aws-plugin.html
To configure keyring_aws, you must obtain a secret access key that provides credentials for communicating with AWS KMS and write it to a configuration file: Create an AWS KMS account. Use AWS KMS to create a secret access key ID and secret access ...
https://dev.mysql.com/doc/refman/9.7/en/merge-table-advantages.html
For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. As a result, MERGE table collections are very fast to create or remap. (You must still ... MERGE tables can help you solve the following problems: Easily manage a set of log ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
Together the editors and panels enable you to: Build, edit, and run queries Create and edit data View and export results Perform basic RDBMS administrative tasks Color syntax highlighting, context help, and code completion assist you in writing and ... The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, and output ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-add.html
The collection needs to be created with the Schema.createCollection() function before documents can be inserted. The Collection.add() function is for storing documents in a collection, similar to the INSERT statement for an SQL database. It takes a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-overview.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE classification_data; mysql> USE ... This topic ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE regression_data; mysql> USE regression_data; ...