Search Results
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
Normally, column labels are the names of the columns you fetch from database tables. If you're retrieving the value of an expression rather than a table column (as in the example just shown), mysql labels the column using the expression itself.
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
Users' EVENT privileges are stored in the Event_priv columns of the mysql.user and mysql.db tables. In both cases, this column holds one of the values 'Y' or 'N'. For a schema-level EVENT privilege, GRANT creates a row in mysql.db and sets that ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-table.html
The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). TYPE A collection of bit flags with information about the foreign key ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table has these columns: TABLE_ID The table ID of the temporary table. The number includes three hidden columns created by InnoDB (DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR). Use the INFORMATION_SCHEMA COLUMNS table or the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The INNODB_BUFFER_PAGE_LRU table has the same columns as the INNODB_BUFFER_PAGE table, except that the INNODB_BUFFER_PAGE_LRU table has an LRU_POSITION column instead of a BLOCK_ID column. The definition for this page is the same as for ... The ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
It can be useful when inserting all columns from the source table into the target table, and no filtering with WHERE is required. In addition, the rows from TABLE can be ordered by one or more columns using ORDER BY, and the number of rows inserted ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
ndb_import rejects any empty lines which it reads from the CSV file, except when importing a single column, in which case an empty value can be used as the column value. --missing-ai-column Command-Line Format --missing-ai-column='name' Type Boolean ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-table-select.html
This query returns the Name and CountryCode columns from the city table. Pass to the orderBy() method a list of one or more columns to sort by and, optionally, the descending (desc) or ascending (asc) attribute as appropriate. For example, the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-select.html
This query returns the Name and CountryCode columns from the city table. Pass to the order_by() method a list of one or more columns to sort by and, optionally, the descending (desc) or ascending (asc) attribute as appropriate. For example, the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
For mysqldump --tab, the server by default writes table data to .txt files one line per row with tabs between column values, no quotation marks around column values, and newline as the line terminator. INTO OUTFILE.) To enable data files to be ...