Search Results
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
Check this by executing mysql -u root mysql and issuing this SQL statement: SELECT * FROM user; The result should include a row with the Host and User columns matching your client's host name and your MySQL user name. If you do not know the IP ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
REPAIR TABLE Output REPAIR TABLE returns a result set with the columns shown in the following table. Column Value Table The table name Op Always repair Msg_type status, error, info, note, or warning Msg_text An informational message The REPAIR TABLE ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...A ... The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-limitations.html
LOAD DATA with ALGORITHM=BULK supports tables with at least one column with the VECTOR data type. If you attempt to load a table without at least one column with the VECTOR data type, an error occurs. If the table has instantly added/dropped ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...For MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. When a full-text index is dropped, the FTS_DOC_ID column that was created for the ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-mysqlclient.html
MySqlCommandBuilder Automatically generates single-table commands used to reconcile changes made to a data set with the associated MySQL database. MySqlParameter Represents a parameter to a MySql.Data.MySqlClient.MySqlCommand, and optionally, its ...
https://dev.mysql.com/doc/connectors/en/connector-python-coding.html
This is especially important for columns that make up the primary key for an InnoDB table, because those column values are duplicated within each secondary index. Even when accepting input generated by some other program, expect that the other ...
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-mysqlclient.html
MySqlCommandBuilder Automatically generates single-table commands used to reconcile changes made to a data set with the associated MySQL database. MySqlParameter Represents a parameter to a MySql.Data.MySqlClient.MySqlCommand, and optionally, its ...
https://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
This is especially important for columns that make up the primary key for an InnoDB table, because those column values are duplicated within each secondary index. Even when accepting input generated by some other program, expect that the other ...