A quick and easy way to select 100 rows randomly from a sqlite database:
SELECT * FROM UserRules ORDER BY Random() LIMIT 100
Filed under: python, sql | Tagged: python, select random rows, sqlite | Leave a comment »
A quick and easy way to select 100 rows randomly from a sqlite database:
SELECT * FROM UserRules ORDER BY Random() LIMIT 100
Filed under: python, sql | Tagged: python, select random rows, sqlite | Leave a comment »
Found a great tutorial for getting started with sqlite. Versions of Python over 2.5 have sqlite included automatically, so no additional installations this time, for a change 🙂
Check out SQLite Python Tutorial at zetcode.com.
Filed under: python | Tagged: python, python sqlite tutorial, sqlite | Leave a comment »