Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-table.html
The Table object represents a database table existsInDatabase(): Returns true if the table exists in the current database, otherwise false. count(): Returns the number of rows in this table if it exists in the current database, otherwise throws an ...See also Section 27.6, “Using Views”, for further information about database views in ...
https://dev.mysql.com/doc/refman/9.7/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-output-table-format.html
The table format is used by default for printing result sets when MySQL Shell is in interactive mode. The results of the query are presented as a formatted table for a better view and to aid analysis. To get this output format when running in batch ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-views-table.html
You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. This column has ...VIEW_DEFINITION The SELECT statement that provides the definition of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-columns-table.html
The rpd_columns table provides column encoding information for columns of tables loaded in MySQL HeatWave. The rpd_columns table has these columns: TABLE_ID A unique identifier for the table. DATA_PLACEMENT_INDEX The data placement key index ID ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-columns-extensions-table.html
The COLUMNS_EXTENSIONS table provides information about column attributes defined for primary and secondary storage engines. The COLUMNS_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs.
https://dev.mysql.com/doc/refman/9.7/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.5, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. Times in ...EVENT_SCHEMA The name of the schema (database) to which the event ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-user-attributes-table.html
The USER_ATTRIBUTES table provides information about user comments and user attributes. The USER_ATTRIBUTES table has these columns: USER The user name portion of the account to which the ATTRIBUTE column value applies. The access control system ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. Examples in this section use the city table in the world_x schema. city Table Description The city table has five columns (or fields). You can combine traditional data ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. Examples in this section use the city table in the world_x schema. city Table Description The city table has five columns (or fields). You can combine traditional data ...