MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 141 to 150 of 158 total results

19.1.3.8 Stored Function Examples to Manipulate GTIDs

https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-functions.html

This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html

This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or ...

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

This is subject to false positives, but serves as a quick rejection test. 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, ...

15.2.15.5 Row Subqueries

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

If the t2 row col3 and col4 values are not equal the col1 and col2 values of any t1 row, the expression is FALSE and the query returns an empty result set. Scalar or column subqueries return a single value or a column of values. A row subquery is a ...

2.7 Installing MySQL on Solaris

https://dev.mysql.com/doc/refman/9.7/en/solaris-installation.html

Note MySQL 9.7 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a Solaris ...

27.3.7.1 Simple Statements

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

Calling this instance's execute() method yields an SqlResult; we can get the names of the columns in this result set using getColumnNames(), and iterate through all its rows by calling fetchOne() until it fails to return another row (that is, until ... A simple statement returns a result set which can be used to access data (rows), metadata, and diagnostic ...

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

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

27.3.6.1 Session Object

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

Returns a string or a true-false value depending on the option type. 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 ...

27.3.6.2 SqlExecute Object

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

Returns a string or true/false value, depending on the option's type. 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 ...

Displaying 141 to 150 of 158 total results