Search Results
https://dev.mysql.com/doc/refman/9.7/en/sorted-index-builds.html
It does not apply to external pages used for TEXT or BLOB entries. Sorted Index Builds and Full-Text Index Support Sorted index builds are supported for fulltext indexes. Previously, SQL was used to insert entries into a fulltext index. InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-simple-statements.html
We obtain an instance of SqlExecute by passing this text to the global Session object's sql() method. A simple statement returns a result set which can be used to access data (rows), metadata, and diagnostic information. A simple statement is ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html
Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...
https://dev.mysql.com/doc/refman/9.7/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Note Fixed-length row format is available only for tables having no BLOB or TEXT columns. Of the three MyISAM storage formats, static format is the ...
https://dev.mysql.com/doc/refman/9.7/en/storage-engines.html
Support for FULLTEXT indexes is available in MySQL 5.6 and later.7. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-bytes.html
Note format_bytes() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_BYTES() function instead. See Section 14.22, “Performance Schema Functions” Given a byte ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-time.html
Note format_time() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_PICO_TIME() function instead. See Section 14.22, “Performance Schema Functions” Given a ...
https://dev.mysql.com/doc/refman/9.7/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/windows-create-option-file.html
Whichever option file you use, it must be a plain text file. An option file can be created and modified with any text editor, such as Notepad. If you need to specify startup options when you run the server, you can indicate them on the command line ...
https://dev.mysql.com/doc/refman/9.7/en/windows-start-service.html
Place your cursor at the end of the text appearing in the space marked Variable Value. On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A ...