Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-library.html
To execute CREATE LIBRARY, the user must have the CREATE ROUTINE privilege. To use a library created within a stored program using this statement, the user must have the EXECUTE privilege. CREATE LIBRARY [IF NOT EXISTS] [database.]library LANGUAGE ...Invalid code causes the statement to be rejected with an ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-creating.html
On the Create MySQL HeatWave Cluster dialog, provide the following information: Basic Information Display Name: Specify a user-friendly display name for the MySQL HeatWave Cluster. Creating a MySQL HeatWave Cluster 4.1 Creating a MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/create-spatial-reference-system.html
Users should not create SRSs with SRIDs in the reserved ranges. srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This ...The ...
https://dev.mysql.com/doc/refman/9.7/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/internals/en/creating-handlerton.html
Possible values are defined in sql/handler.h and copied here: #define HTON_NO_FLAGS 0 #define HTON_CLOSE_CURSORS_AT_COMMIT (1 << 0) #define HTON_ALTER_NOT_SUPPORTED (1 << 1) #define HTON_CAN_RECREATE (1 << 2) #define HTON_FLUSH_AFTER_RENAME (1 << 3) ...This is the name that will be used when creating tables (CREATE TABLE ... The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those methods that apply to the ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-generated-columns.html
A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ...Values of ...
https://dev.mysql.com/doc/refman/9.7/en/windows-create-option-file.html
Note When using MySQL Configurator to configure MySQL Server, it creates the my.ini at the default location, and the user executing MySQL Configurator is granted full permissions to this new my.ini file. In other words, be sure that the MySQL Server ... If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option ...
https://dev.mysql.com/doc/refman/9.7/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 ...The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-extension-objects-create.html
If you create a dictionary with no list of options, any options that the end user specifies for the dictionary are passed directly through to the function by MySQL Shell with no validation. MySQL Shell validates the options specified by the end user ...The name must be a valid scripting identifier, so the first character must be a letter or underscore character, followed by any number of letters, numbers, or underscore ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-create.html
You can create and register a user-defined report for MySQL Shell in either of the supported scripting languages, JavaScript and Python. The reporting facility handles built-in reports and user-defined reports using the same API frontend scheme.