Search Results
https://dev.mysql.com/doc/refman/9.7/en/password-logging.html
In particular, INSERT or UPDATE statements for the mysql.user system table that refer to literal passwords are logged as is, so you should avoid such statements. (Direct modification of grant tables is discouraged, anyway.) For the general query ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-full-text-plugins.html
Table 4.3 Full-Text Parser Token Types Token Value Meaning FT_TOKEN_EOF End of data FT_TOKEN_WORD A regular word FT_TOKEN_LEFT_PAREN The beginning of a group or subexpression FT_TOKEN_RIGHT_PAREN The end of a group or subexpression FT_TOKEN_STOPWORD ... MySQL supports server-side full-text parser plugins with MyISAM and ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-data-sets.html
Data items can be read from the database using Collection.find(), Table.select() and Session.sql(). Collection.find() returns a data set with documents and Table.select() respectively Session.sql() return a data set with rows. var myColl = ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode.html
MySQL 9.7 also displays utf8mb3 in place of utf8 in the columns of Information Schema tables, and in the output of SQL SHOW statements. Table 12.2, “Unicode Character Set General Characteristics”, summarizes the general characteristics of ...
https://dev.mysql.com/doc/refman/9.7/en/diagnostics-area.html
CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME: Strings that indicate the catalog, schema, table, and column related to the condition. SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a ...
https://dev.mysql.com/doc/refman/9.7/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-rolling-restart.html
To free memory previously allocated to a table by successive INSERT and DELETE operations, for re-use by other NDB Cluster tables. Other parameters require that the data node be stopped completely using the management client STOP command, then ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-libraries.html
To be importable, the function must be declared with the export keyword. You can obtain general information about JavaScript libraries by querying the Information Schema LIBRARIES table; the Information Schema ROUTINE_LIBRARIES shows imports into ...
https://dev.mysql.com/doc/refman/9.7/en/stored-objects.html
Trigger: An object created with CREATE TRIGGER that is associated with a table. A trigger is activated when a particular event occurs for the table, such as an insert or update. JSON Relational Duality View: An object created with CREATE JSON ...
https://dev.mysql.com/doc/refman/9.7/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.27, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.13, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.40, ...