Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-table-select.html
Avoid introducing values in queries using string concatenation, which can produce invalid input and, in some cases, can cause security issues. mysql-js> db.country.select(["Code", "Name"]).orderBy(["Name desc"]).limit(3).offset(1) ... You can use ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-select.html
Avoid introducing values in queries using string concatenation, which can produce invalid input and, in some cases, can cause security issues. mysql-py> db.country.select(["Code", "Name"]).order_by(["Name desc"]).limit(3).offset(1) ... You can use ...
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
In a C program, you can escape a binary value using mysql_real_escape_string_quote() and include the result in a query string that is sent to the server. After you have created spatial columns, you can populate them with spatial data. Values should ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
For a full explanation of the internal format of DECIMAL values, see the file strings/decimal.c in a MySQL source distribution. The format is explained (with an example) in the decimal2bin() function. This section discusses the characteristics of ...
https://dev.mysql.com/doc/refman/8.4/en/query-attribute-components.html
Purpose: Implements the mysql_query_attribute_string() function that takes an attribute name argument and returns the attribute value as a string, or NULL if the attribute does not exist. A component service provides access to query attributes (see ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
Parameter markers can be used only where data values should appear, and they cannot be used for SQL keywords, identifiers, functions, and so on. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
For example, LIMIT requires literal integer arguments, and LOAD DATA requires a literal string file name. The preceding query can also be written like this, using TABLE: SELECT (TABLE t2) FROM t1; A scalar subquery can be part of an expression, but ... In its simplest form, a subquery is a scalar subquery that returns a single ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-single-file.html
To avoid having a large number of backup files to keep track, store, and transport, mysqlbackup conveniently creates backups in a single-file format. It can also pack an existing backup directory into a single file, unpack the single file back to a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-debug.html
void mysql_debug(const char *debug) Description Does a DBUG_PUSH with the given string. To use this function, you must compile the client library to support debugging. Example The call shown here causes the client library to generate a trace file ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-more-results.html
bool mysql_more_results(MYSQL *mysql) Description This function is used when you execute multiple statements specified as a single statement string, or when you execute CALL statements, which can return multiple result sets. mysql_more_results() ...