Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/information-schema-libraries-table.html
The LIBRARIES table contains information about JavaScript and WebAssembly libraries known to the MLE JavaScript component (see Section 7.5.7, “Multilingual Engine Component (MLE)”). This is a set consisting of none or any one or more of the ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-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-py> 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 ...