Menu
Is there any equivalent to psql's \x to view a record with each column on a new row?
480
The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following EXPLAIN . As of MySQL 8.0. 12, extended information is available for SELECT , DELETE , INSERT , REPLACE , and UPDATE statements.
Logging messages sent to the console are given the verbose: prefix. When you send logging information to the console, it is still sent to the application log file. To send logging information to the console as verbose output, choose one of these options: Use the --verbose command-line option when starting MySQL Shell.
The Output is located at the bottom of MySQL Workbench. Its select box includes the Action Output , History Output , and Text Output options.
To exit from mysql type quit at the mysql> command-prompt.
Append \G to the end of the statement before the semicolon:
SELECT * FROM table_name [WHERE condition] \G;
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
