Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-output-vertical.html
The vertical format option prints result sets vertically instead of in a horizontal table, in the same way as when the \G query terminator is used for an SQL query. Vertical format is more readable where longer text lines are part of the output. To ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-create-example.html
This example user-defined report sessions shows which sessions currently exist.
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-create.html
MySQL Shell displays the output in table format by default, or in vertical format if the --vertical or --E option was specified on the \show or \watch command. You can create and register a user-defined report for MySQL Shell in either of the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-run.html
The \show command also provides the following standard options: --vertical (or -E) displays the results from a report that returns a list in vertical format, instead of table format. Built-in reports and user-defined reports that have been ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-sql-system-log.html
Mar 1 17:35:33 myhost mysqlsh[33060]: SYSTEM_USER=hanna_j MYSQL_USER=hanna CONNECTION_ID=14 DB_SERVER=localhost DB='--' QUERY='create table test.test (c int, my_row_id BIGINT AUTO_INCREMENT INVISIBLE PRIMARY KEY);' . SQL statements that you issue ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-debug-slowquery-diagnostics.html
About the Utility Requirements and Restrictions Running the Utility Options for Collecting Diagnostics About the Utility util.debug.collectSlowQueryDiagnostics() runs multiple iterations of diagnostic reporting on your MySQL server, enabling you to ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-json-bson.html
The following example imports documents from the file /europe/regions.json to the column jsondata in a relational table named regions in the mydb database. When you specify the convertBsonTypes: true (--convertBsonTypes) option to convert BSON data ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-asynchronous-interface-usage.html
CREATE DATABASE db; USE db; CREATE TABLE test_table (id INT NOT NULL); INSERT INTO test_table VALUES (10), (20), (30); CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'; GRANT ALL ON db.* TO 'testuser'@'localhost'; Create a file named ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-prepared-statement-data-structures.html
The MYSQL_TIME structure contains the members listed in the following table. Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-bind-param.html
Each attribute type most be one of the MYSQL_TYPE_xxx types listed in Table 6.1, “Permissible Input Data Types for MYSQL_BIND Structures”, except that MYSQL_TYPE_BLOB and MYSQL_TYPE_TEXT are not supported. bool mysql_bind_param(MYSQL *mysql, ...