On this page

SET LIST

Core command SELI

Shows query results as a table (OFF, the default) or one row at a time as a form (ON).

Syntax

SET LIST ON|OFF

Argument	Required	Values	Default
`ON` or `OFF`	Yes	`ON` for the form view, `OFF` for the table view. `TRUE` and `FALSE` work too.	None

SET LIST ON;
SELECT * FROM CUSTOMER WHERE ID = 42;
SET LIST OFF;

OFF, the default: results are a table, one row per line.
ON: each row is shown as a form, one column per line, which suits a wide result that does not fit the screen.

The setting lasts for the session. Anything other than ON, OFF, TRUE or FALSE, in any case, is refused.

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.