Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM sqlite_master WHERE name = 'sqlite_autoindex_user_1'
- PRAGMA index_info(sqlite_autoindex_user_1);
- PRAGMA INDEX_LIST('table_name');
- select count(*) from t
- group by foo, bar, baz
- having count(*) > 1
- select count(*) from (
- select count(*) from t
- group by foo, bar, baz
- having count(*) > 1
- )
Add Comment
Please, Sign In to add comment