.#¶
.# repeats a previous SQL a number of times.
This command is primarily designed for developers to resend a previous SQL to the database.
Syntax¶
usage: .# [number]
You can use the shorthand syntax like the following.
.5
which is the same as
.# 5
Example¶
INSERT INTO MyTable
SELECT a + (SELECT MAX(a) FROM MyTable),
'POINT(' || (a + (SELECT MAX(a) FROM MyTable)) || ' ' || (a + (SELECT MAX(a) FROM MyTable)) || ')'
FROM MyTable;
-- Looks like that we need more data.
.4