MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 181 to 190 of 195 total results

7.6.4.2 Using the Rewriter Query Rewrite Plugin

https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html

To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 7.6.4.1, “Installing or Uninstalling the Rewriter Query Rewrite Plugin”). To ...

15.2.15.5 Row Subqueries

https://dev.mysql.com/doc/refman/9.7/en/row-subqueries.html

Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...

27.3.7.1 Simple Statements

https://dev.mysql.com/doc/refman/9.7/en/srjs-api-simple-statements.html

A simple statement returns a result set which can be used to access data (rows), metadata, and diagnostic information. A simple statement is static, and cannot be modified after creation; in other words, it cannot be parametrized. A simple ...

27.3.10.5 LLM Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-llm.html

LLM Constructor LLM.unload() LLM.generate() LLM.embed() LLM.rag() This class represents a large language model. The API also provides convenience methods; see Section 27.3.10.8, “Convenience Methods”. Both versions of these methods support ...

27.3.6.4 Schema Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-schema.html

You can obtain an instance of Schema by calling the Session object's getSchema() method; you can also obtain a list of all available databases by calling getSchemas(). Schema supports the methods listed here: existsInDatabase(): Returns true if the ...

27.3.6.1 Session Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-session.html

The Session object is always available as the session property of the global object. Session has the methods listed here: createSchema(String name): Creates a database having the specified name, and returns the corresponding Schema object. Returns ...

27.3.6.2 SqlExecute Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlexecute.html

SqlExecute has the following methods: execute(): Executes the SQL statement and returns an SqlResult. getOption(String optionName): Gets the value for the named option to this statement. Returns a string or true/false value, depending on the ...

27.3.6.3 SqlResult Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlresult.html

An SqlResult is produced whenever a query is executed using sqlExecute.execute(), PreparedStatement.execute(), or Session.runSql(). Methods supported by SqlResult are listed here: close(): Closes the result set. fetchAll(): Retrieves a list of all ...

14.8.1 String Comparison Functions and Operators

https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html

Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...

30.4.5.16 The ps_thread_stack() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-stack.html

Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...

Displaying 181 to 190 of 195 total results