Search Results
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 ...Creating and Using ENUM Columns Index Values for Enumeration Literals Handling of Enumeration Literals Empty or NULL Enumeration Values Enumeration Sorting Enumeration Limitations Creating and Using ENUM Columns An enumeration value must be a quoted string ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
This topic describes how to run a SELECT query and insert the results into a target table using the INSERT ... The target table can be an InnoDB table and does not need to use a secondary engine. The SELECT table is loaded in MySQL HeatWave, and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-blobs-basic.html
*/ void drop_table(MYSQL &mysql) { if (mysql_query(&mysql, "DROP TABLE api_blob")) MYSQLERROR(mysql); } /* Functions to create table. 'I'm quite content\n" "to stay here--only I AM so hot and thirsty!'\n" "\n" " -- Lewis Carroll, 'Through the ...
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...ibd2sdi can be used at runtime or while the server is ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-export.html
You can then use SHOW_CREATE_TABLE to view information on the table for the exported model. Use the ML_MODEL_EXPORT routine to export a model from the model catalog to a user defined table. ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, ...
https://dev.mysql.com/doc/workbench/en/wb-design-table-templates.html
Define table templates with commonly used columns and settings to create new tables from either a live connection or while creating an EER model. From the SQL editor, select Create Table Like from the Tables context menu, as shown in the next ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-synchronous-transactions.html
It first creates a database ndb_examples and a table api_simple (if these objects do not already exist) using the MySQL C API with an SQL node, then performs a series of basic data operations (insert, update, read, and select) on this table using ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-environment-category.html
Keep Files On Create Enabled If a MyISAM table is created with a DATA DIRECTORY or INDEX DIRECTORY option and an existing .MYD or .MYI file is found, MyISAM always returns an error. Show Old Temporals Enabled Whether SHOW CREATE TABLE output ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
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. Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE ...Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE ...Columns with a spatial data type can have an SRID attribute, to explicitly ...