Search Results
https://dev.mysql.com/doc/refman/8.4/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. For example, a column specified as SET('one', 'two') NOT NULL can have any of these ...SET ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
You see only those databases for which you have some kind of privilege, unless you have the global SHOW DATABASES privilege. If the server was started with the --skip-show-database option, you cannot use this statement at all unless you have the ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
If you have the PROCESS privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where ...Where that is true, those descriptions take precedence over the general discussion ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
However, the optimizer cannot use SPATIAL indexes on them until the column definition is modified to include an SRID attribute, which may require that the column contents first be modified so that all values have the same SRID. MySQL has spatial ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
This is due to a change in 5.6.4 that permits these types to have a fractional part, which requires from 0 to 3 bytes. DATETIME is packed more efficiently, requiring 5 rather than 8 bytes for the nonfractional part, and all three parts have a ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
A string object that can have only one value, chosen from the list of values 'value1', 'value2', ..., NULL or the special '' error value. An ENUM column can have a maximum of 65,535 distinct elements. A string object that can have zero or more ...
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
Structured variable instances and components follow these naming rules: For a given type of structured variable, each instance must have a name that is unique within variables of that type. Currently, the first two rules have no possibility of being ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...