SHOW QUERY

Core command SH QU SHQU

Displays the current SQL query stored in memory

Arguments

None.

Examples

SHOW QUERY;

Notes

Displays the last SQL statement run in the session: SHOW QUERY. Takes no arguments. Prints "No query in memory" if none has been executed yet, collapsed onto a single line otherwise (see toSingleLine(String)), convenient for reading and copy-paste even if the query was originally typed or pasted across several lines. This is the same statement replayed by the / macro (and by / <environment>, which reruns it transiently against another connection instead - see CommandInterpreter.handleSlashRerun); the // macro (handled in CommandInterpreter) is a true alias - it looks up this same registered command instance and calls this exact execute(String), rather than keeping its own copy of the display logic.

Last modified in release 5.1.6.