Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-applicable-roles-table.html
The APPLICABLE_ROLES table provides information about the roles that are applicable for the current user. The APPLICABLE_ROLES table has these columns: USER The user name part of the current user account. IS_GRANTABLE YES or NO, depending on ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-collation-character-set-applicability-table.html
The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is associated. Notes The COLLATION_CHARACTER_SET_APPLICABILITY ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-enabled-roles-table.html
The ENABLED_ROLES table provides information about the roles that are enabled within the current session. The ENABLED_ROLES table has these columns: ROLE_NAME The user name part of the granted role. IS_DEFAULT YES or NO, depending on whether the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimizer-trace-table.html
The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-resource-groups-table.html
The RESOURCE_GROUPS table provides access to information about resource groups. The RESOURCE_GROUPS table has these columns: RESOURCE_GROUP_NAME The name of the resource group. For general discussion of the resource group capability, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-role-routine-grants-table.html
The ROLE_ROUTINE_GRANTS table provides information about the routine privileges for roles that are available to or granted by the currently enabled roles. The ROLE_ROUTINE_GRANTS table has these columns: GRANTOR The user name part of the account ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-units-of-measure-table.html
The ST_UNITS_OF_MEASURE table provides information about acceptable units for the ST_Distance() function. The ST_UNITS_OF_MEASURE table has these columns: UNIT_NAME The name of the unit.
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-table-update.html
You can use the update() method to modify one or more records in a table. To replace a city name in the city table, pass to the set() method the new city name. mysql-js> db.city.select(["ID", "Name", "CountryCode", "District", "Info"]).where("Name ...The update() method works by filtering a query to include only the records to be updated and then applying the operations you specify to those ...