MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 141 to 150 of 155 total results

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 ...

27.3.6.3 SqlResult Object

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

hasData(): Returns true if the most recently executed statement yielded a result set, false otherwise. An SqlResult is produced whenever a query is executed using sqlExecute.execute(), PreparedStatement.execute(), or Session.runSql(). Methods ...

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 141 to 150 of 155 total results