Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-function.html
SHOW CREATE FUNCTION func_name This statement is similar to SHOW CREATE PROCEDURE but for stored functions.
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed.
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
Binary strings are sequences of bytes and the numeric values of those bytes determine comparison and sort order. The binary collation differs from _bin collations in several respects, discussed in the following sections: The Unit for Comparison and ... This section describes how the binary collation for binary strings compares to _bin collations for nonbinary ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
*/ C-style comment syntax, with a + character following the /* comment opening sequence. Consider this sequence of statements: SET @saved_val = @@SESSION.var_name; SET @@SESSION.var_name = value; SELECT ... SET @@SESSION.var_name = @saved_val; The ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
The following options apply to CREATE TABLE and ALTER TABLE statements. This topic contains the following sections: CREATE TABLE Statement External Table Options with SQL Syntax Column Definitions Table Parameters File Specifications File Format ...
https://dev.mysql.com/doc/workbench/en/wb-create-new-table.html
Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure shows. Figure 9.33 Model: Creating A New Table Initially, the table name defaults to 'table1' in the table editor. This action opens the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-create-target.html
Note The Recreate Objects operation is required to save any changes here. It will then execute the previous migration step (Create Schemas) with the modified code, and then continue the migration process. The generated objects are listed here, ...
https://dev.mysql.com/doc/internals/en/creating-build-directory.html
The build directory can actually be a subdirectory of the source tree rather than a directory located outside it; the point is that files generated during the build process (such as .o files) are created under the build directory, not in the ... One ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-created-users.html
These credentials are used to create the repository and its tables and to record data in them. At the end of MySQL Enterprise Service Manager installation, the file configuration_report.txt is created, and along with other configuration details, ...