How to check whether a table is empty or not in sqlite.

[bhaskarReddy]

HI Friends,

How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.


Can any one tell me how to check if table in a data base is empty
or not, using sqlite3.


Regards,
Bhaskar.

[Igor Tandetnik]

Post by bhaskarReddy
How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.

select exists (select 1 from MyTable);

[Simon Slavin]

Post by Igor Tandetnik

Post by bhaskarReddy
How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.

select exists (select 1 from MyTable);

Or

SELECT COUNT(*) from MyTable

which will give you 0 if the table is empty, and some other integer otherwise.

Simon.

[Jay A. Kreibich]

Post by Simon Slavin

Post by Igor Tandetnik

Post by bhaskarReddy
How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.

select exists (select 1 from MyTable);

SELECT COUNT(*) from MyTable

For a large table, that might take some time.

-j

[Kit]

Post by Igor Tandetnik

       How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.

select exists (select 1 from MyTable);

SELECT exists(SELECT 1 FROM MyTable LIMIT 1);

[Igor Tandetnik]

Post by Kit

Post by Igor Tandetnik

Post by bhaskarReddy
How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.

select exists (select 1 from MyTable);

SELECT exists(SELECT 1 FROM MyTable LIMIT 1);

exists() predicate is smart enough to stop as soon as the first row is
retrieved. LIMIT 1 clause is redundant, though harmless.