Search Results
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
Only mysql is supported as the scheme value at this point. To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
Instead, the table definition includes a connection string that points to the remote table. When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
For example, if mysql is the firewall database: CALL mysql.sp_set_firewall_group_mode(group, mode); In MySQL 8.4, firewall stored procedures are transactional; if an error occurs during execution of a firewall stored procedure, all changes made by ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
At this point, the tables are locked and quiescent: The tables are in a transactionally consistent state on disk and you can copy the .ibd tablespace files along with the corresponding .cfg files to get a consistent snapshot of those tables. | ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is a set of one or more columns included in a FULLTEXT index. For each row in the ...
https://dev.mysql.com/doc/refman/8.4/en/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Expressions can be written using values ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-geometrycollection.html
Restrictions may be based on: Element type (for example, a MultiPoint may contain only Point elements) Dimension Constraints on the degree of spatial overlap between elements . A GeomCollection is a geometry that is a collection of zero or more ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-multisurface.html
Surfaces within a MultiSurface have boundaries that intersect at most at a finite number of points. A MultiSurface is a geometry collection composed of surface elements. MultiSurface Assertions Surfaces within a MultiSurface have no interiors that ...
https://dev.mysql.com/doc/refman/8.4/en/gis-format-conversion-functions.html
mysql> SET @g = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_GeomFromText(@g)); +--------------------------------+ | ST_AsText(ST_GeomFromText(@g)) | +--------------------------------+ | LINESTRING(1 1,2 2,3 3) | ... MySQL supports the ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
This is because MySQL is dependent on the host system for name resolution, but has no way of knowing whether it is working—from MySQL's point of view the problem is indistinguishable from any other network timeout. This section also covers the ...