MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 291 to 300 of 310 total results

27.3.12 JavaScript Stored Program Examples

https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html

This section contains examples illustrating a number of different aspects of using JavaScript programs under various circumstances. The following example demonstrates the use of a JavaScript stored function with table column values. Next, we create ...

27.3.6.12 MySQL Functions

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

These are described in the following list, along with their analogous SQL functions: rand() (MySQL RAND()): Returns a random floating-point value v in the range 0 <= v < 1.0. The following SQL built-in functions can be called directly from the ...

Chapter 18 Alternative Storage Engines

https://dev.mysql.com/doc/refman/9.7/en/storage-engines.html

row *************************** Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO XA: NO Savepoints: NO *************************** 2. row *************************** Engine: InnoDB Support: DEFAULT Comment: ...

27.10 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/9.7/en/stored-program-restrictions.html

Prepared statement scope is the current session, not the stored program, so the statement could be executed after the program ends, at which point the variables would no longer be in scope. Some of the restrictions noted here apply to all stored ...

27.9 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/9.7/en/stored-programs-logging.html

These events bring databases up to date from the point of the backup. The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications.

15.2.15 Subqueries

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

All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...

2.9.3 Testing the Server

https://dev.mysql.com/doc/refman/9.7/en/testing-server.html

After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...

7.6.3.4 Thread Pool Tuning

https://dev.mysql.com/doc/refman/9.7/en/thread-pool-tuning.html

You may need to adjust the value from this starting point to suit a given workload; a reasonable upper bound for this value is the maximum number of concurrent connections expected; the value of the Max_used_connections status variable can serve as ... This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per ...

13.2.3 The TIME Type

https://dev.mysql.com/doc/refman/9.7/en/time.html

The only delimiter recognized between a time part and a fractional seconds part is the decimal point. By default, values that lie outside the TIME range but are otherwise valid are clipped to the closest endpoint of the range. MySQL retrieves and ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/9.7/en/user-variables.html

User variables can be assigned a value from a limited set of data types: integer, decimal, floating-point, binary or nonbinary string, or NULL value. You can store a value in a user-defined variable in one statement and refer to it later in another ...

Displaying 291 to 300 of 310 total results