https://dev.mysql.com/mysql-shell-tutorial-javascript-documents-collections.html
Simple document format for JavaScript: {field1: "value", field2 : 10, "field 3": null} An array of documents consists of a set of documents separated by commas and enclosed within [ and ] characters. When you are using MySQL as a Document Store, ...
https://dev.mysql.com/mysql-shell-tutorial-javascript-indexes-create.html
The final parameter indicates whether the field should require the NOT NULL constraint. If the value is false, the field can contain NULL values. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must ...
https://dev.mysql.com/mysql-shell-tutorial-python-documents-index.html
The final parameter indicates whether the field should require the NOT NULL constraint. If the value is false, the field can contain NULL values. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must ...
https://dev.mysql.com/mysql-sqlstate.html
const char *mysql_sqlstate(MYSQL *mysql) Returns a null-terminated string containing the SQLSTATE error code for the most recently executed SQL statement. '00000' means “no error.” The values are specified by ANSI SQL and ODBC. For a list of ...
https://dev.mysql.com/mysql-ssl-set.html
bool mysql_ssl_set(MYSQL *mysql, const char *key, const char *cert, const char *ca, const char *capath, const char *cipher) mysql_ssl_set() is used for establishing encrypted connections using SSL. mysql_ssl_set() does nothing unless SSL support is ...
https://dev.mysql.com/mysql-stmt-sqlstate.html
const char *mysql_stmt_sqlstate(MYSQL_STMT *stmt) For the statement specified by stmt, mysql_stmt_sqlstate() returns a null-terminated string containing the SQLSTATE error code for the most recently invoked prepared statement API function that can ..."00000" means “no error.” The values are specified by ANSI SQL and ...
https://dev.mysql.com/mysql-use-result.html
When using mysql_use_result(), you must execute mysql_fetch_row() until a NULL value is returned, otherwise, the unfetched rows are returned as part of the result set for your next query. MYSQL_RES *mysql_use_result(MYSQL *mysql) After invoking ...
https://dev.mysql.com/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. Once your data reaches a ...
https://dev.mysql.com/performance-schema-atom-molecule-events.html
For example, a row fetch might result in rows like this: Row# EVENT_NAME TIMER_START TIMER_END ---- ---------- ----------- --------- 1 wait/io/file/myisam/dfile 10001 10002 2 wait/io/table/sql/handler 10000 NULL The row fetch causes a file read. In ... For a table I/O event, there are usually two rows in events_waits_current, not ...
https://dev.mysql.com/performance-schema-obtaining-parent-events.html
FROM performance_schema.events_transactions_current AS parent INNER JOIN performance_schema.data_locks AS child WHERE parent.THREAD_ID = child.THREAD_ID AND parent.EVENT_ID < child.EVENT_ID AND ( child.EVENT_ID <= parent.END_EVENT_ID OR ...Rows of ...
