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. Reserved words are permitted as identifiers if you quote them as described in Section 11.2, ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
CMake Option Reference General Options Installation Layout Options Storage Engine Options Feature Options Compiler Flags CMake Options for Compiling NDB Cluster CMake Option Reference The following table shows the available CMake options. If it is ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are recorded against individual tables and returned as part of the field data. You can obtain a list of the available character sets configured within a server by running SHOW COLLATION, or by running a query on the ... Character sets ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
To insert a new row into the table, first create a new instance of Employee. This can be accomplished by calling the Session method newInstance(), as shown here: Employee newEmployee = session.newInstance(Employee.class); Set the Employee instance ...For example, the following sets the id, firstName, lastName, and started ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
This includes the server data directory containing the files that implement the privilege tables. In addition to user data, the data directory contains data dictionary and system tables, which store sensitive information about database objects, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-ratings-rankings.html
mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace ... This ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Select either of the following SSL modes: Disabled: Establishes an unencrypted connection between the source and target. Required: (Default) If the server supports encrypted connection, establishes an encrypted connection. The connection attempt ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. Use the CREATE TABLE statement to create a table ...See also the notes about spatial indexes under Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. Handling of Enumeration Literals Trailing spaces are automatically deleted from ENUM ...See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Indexes are especially important for queries that reference ...