SQLite Getting empty result from any query

Question

Here is weird question: do i make SELECT query that will always return nothing from some database?Preferably fast,but not necessary.

For example,i have some random table Events,and i can do that simple way,by looking for record that will probably never exist:

"SELECT * FROM Events WHERE EventName = 'ajsiLfjh28v0djkf9409fda'

But that is very ugly solution.Is there a better way to do it?I can't find anything,mostly because i am unsure what to look for.

I have few classes where getting any kind of query results is crucial and don't want to change them,and i also can't just send them empty data. — user2363676
– user2363676, Commented May 15, 2013 at 23:04

Shawn Balestracci · Accepted Answer · 2013-05-15 23:07:10Z

1

You can build on this basic empty query:

select 0 where 0;

You can make any query return nothing by throwing AND 0 at the end of the where clause (unless there is no where clause.)

answered May 15, 2013 at 23:07

Shawn Balestracci

7,5601 gold badge37 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Larry McKenzie · Accepted Answer · 2013-05-15 23:07:01Z

1

I really don't understand but if you want to make sure no result s are returned add a limit of 0

SELECT * FROM Events LIMIT 0

answered May 15, 2013 at 23:07

Larry McKenzie

3,29327 silver badges23 bronze badges

teckno101 · Accepted Answer · 2013-05-15 22:54:33Z

0

How about

SELECT * FROM Events WHERE null!=null

answered May 15, 2013 at 22:54

teckno101

11 bronze badge