MySQL & Python- Error: 2006 mysql has gone away

MySQL & Python: Error: 2006 mysql has gone away This problem occurs for multiple reasons such as DB connection problem. In our code, we hit this issue due to a subtle problem with DB cursor. The code was as following: with conn as cur: try: print “hello” except: print “sorry” finally: conn.close() The above code […]

Read more

Part I MySQL for beginners: Frequent commands

I am dabbling my feet in SQL after a long time. I studied RDBMS in academics and worked briefly on SQLite. Following is a list of commands, errors and suggestion, I have come across. This information is collection from various independent sources. SQL Server Table Column Types: bigint    Integer value (-9,223,372,036,854,775,808 – 9,223,372,036,854,775,807)    2^63 int   […]

Read more