2012/2/13 Igor Tandetnik <[email protected]>: > bhaskarReddy <[email protected]> wrote: >> 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); -- Kit _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
