Python: installing sqlparse module

The process was a little involved and required the installation of a few sub modules.  Here’s what I needed to get done to complete the entire process: URL: https://github.com/andialbrecht/sqlparse Download package & extract package Open command prompt Navigate to the packag
Continue Reading →

SQL: SELECT random number of rows

Here’s a quick way of requesting a random number of rows from a MySQL database: SELECT * FROM <'table'> ORDER BY rand() limit <'n'>; tablename: is the name of the table you wish to access n: is thenumber of rows you wish to return Be careful thoug
Continue Reading →