Search Results
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
And now we're going to walk through something harder, namely the server. WARNING WARNING WARNING: code changes constantly, so names and parameters may have changed by the time you read this. Important files we'll be walking through: /sql/mysqld.cc ...
https://dev.mysql.com/doc/internals/en/implementing-basic-table-scanning.html
Such engines might be used to support SQL queries of logs and other data files that are populated outside of MySQL. The implementation of the methods in this section provide the first steps toward the creation of more advanced storage engines.
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
Next I'll describe the physical attributes of each column in a row. The format depends entirely on the data type and the size of the column, so, for every data type, I'll give a description and an example. All the types are defined within the ...
https://dev.mysql.com/doc/internals/en/store-lock.html
Synopsis virtual THR_LOCK_DATA ** store_lock ( thd, to, lock_type); THD * thd ; THR_LOCK_DATA ** to ; enum thr_lock_type lock_type ; Description This is the store_lock method. The idea with handler::store_lock() is the following: The statement ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-clusterjdatastoreexception-classification.html
Table 4.6 lookup(int) Parameter Description value the classification returned by getClassification() return the Classification for the error .
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.html
CAST() from and to all the MySQL HeatWave supported numeric, temporal, string and text data types. CAST() of ENUM columns to CHAR, DECIMAL, FLOAT, and to SIGNED and UNSIGNED numeric values. CAST() operates on the ENUM index rather than the ENUM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY clauses in the following cases: In queries that contain distinct aggregations. Cursors inside stored programs are not supported ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. The syntax of ...