Seeking Sqlite no-op command

Question

Is there a command which I can run to do nothing (or very little) which will never error?

I need something for testing porpoises.

I'm intrigued — how do you test [porpoises](http://en.wikipedia.org/wiki/Porpoise)? — CL., Jan 30 '14 at 09:06

score 8 · Accepted Answer · answered Jan 30 '14 at 09:11

8

A comment does nothing (but your database driver might complain if there is not command at all):

/* Hello, world! */

Unknown PRAGMA statements are ignored, and do not return anything:

PRAGMA testing_porpoises;

If you need a statement that returns an empty result set, you need a SELECT:

SELECT 0 WHERE 0;

answered Jan 30 '14 at 09:11

CL.

2

"PRAGMA testing_porpoises;" it is ;-) Thanks – Mawg says reinstate Monica Mar 21 '15 at 14:33

score 5 · Answer 2 · answered Jan 30 '14 at 08:29

5

For example a simple constant select could do:

SELECT 1 WHERE 0;

answered Jan 30 '14 at 08:29

laalto

2 Answers2