Search Results
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysqlsh.html
This authentication type is only suitable for a secure connection that uses SSL or sockets, so you must configure the secure connection before using it. --connect-timeout=ms Configures how long MySQL Shell waits (in milliseconds) to establish a ...
https://dev.mysql.com/doc/workbench/en/wb-validation-plugins.html
In addition, the output is organized by category: Validating routine groups, Validating routines, Validating tables, and Validating views. MySQL Workbench provides validation modules so that you can test your models before implementing them. The ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object body. p2 fails if the invoker lacks the EXECUTE privilege for p2 or the UPDATE privilege for the table t1. The server ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/internals/en/implementing-info-method.html
Prior to commencing a table scan, the [custom-engine.html#custom-engine-api-reference-info info()] method is called to provide extra table information to the optimizer. The stats member is an instance of the ha_statistics class which is also ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
Load this data into MySQL HeatWave as an aggregate table by using Auto Parallel Load. Update this table with new data loaded to the same bucket for new aggregates by using the incremental load feature. Therefore, instead of having queries compute ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR TABLE. (Even with ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL statement. You should also bear in mind that ROW() is a row value constructor ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. These functions also permit an optional second argument that specifies an X or Y coordinate value, in which case the function result ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable according to the Open Geospatial Consortium specification. MySQL also implements certain ...