To be a bit more complete: import MySQLdb connection = MySQLdb.connect( host=”localhost”, user=”myself”, passwd = ‘mysecret’) # create the connection cursor = connection.cursor() # get the cursor cursor.execute(“USE mydatabase”) # select the database cursor.execute(“SHOW TABLES”) # execute ‘SHOW TABLES’ (but data is not returned) now there are two options: tables = cursor.fetchall() # return data … Read more
I am not certain, but I am going to guess you are using a INNODB table, and you haven’t done a commit. I believe MySQLdb enable transactions automatically. Call conn.commit() before calling close. From the FAQ: Starting with 1.2.0, MySQLdb disables autocommit by default
You must define the relevant variable to show where your settings.py file lives: export DJANGO_SETTINGS_MODULE=mysite.settings This is the relevant docs entry: When you use Django, you have to tell it which settings you’re using. Do this by using an environment variable, DJANGO_SETTINGS_MODULE. The value of DJANGO_SETTINGS_MODULE should be in Python path syntax, e.g. mysite.settings. Note … Read more
From MySQLdb User’s Guide: c.executemany( “””INSERT INTO breakfast (name, spam, eggs, sausage, price) VALUES (%s, %s, %s, %s, %s)”””, [ (“Spam and Sausage Lover’s Plate”, 5, 1, 8, 7.95 ), (“Not So Much Spam Plate”, 3, 2, 0, 3.95 ), (“Don’t Wany ANY SPAM! Plate”, 0, 4, 3, 5.95 ) ] ) so in your … Read more
If you are using the default cursor, a MySQLdb.cursors.Cursor, the entire result set will be stored on the client side (i.e. in a Python list) by the time the cursor.execute() is completed. Therefore, even if you use for row in cursor: you will not be getting any reduction in memory footprint. The entire result set … Read more
PyMySQL and MySQLdb provide the same functionality – they are both database connectors. The difference is in the implementation where MySQLdb is a C extension and PyMySQL is pure Python. There are a few reasons to try PyMySQL: it might be easier to get running on some systems it works with PyPy it can be … Read more
It should be: cursor.execute (“”” UPDATE tblTableName SET Year=%s, Month=%s, Day=%s, Hour=%s, Minute=%s WHERE Server=%s “””, (Year, Month, Day, Hour, Minute, ServerID)) You can also do it with basic string manipulation, cursor.execute (“UPDATE tblTableName SET Year=%s, Month=%s, Day=%s, Hour=%s, Minute=%s WHERE Server=”%s” ” % (Year, Month, Day, Hour, Minute, ServerID)) but this way is discouraged … Read more
try running the following command: pip install mysqlclient
The error message can be made more comprehensive and helpful. In order to fix this “cryptography” package needs to be installed. pip install cryptography
It looks like python is interpreting the % as a printf-like format character. Try using %%? “SELECT fileid FROM files WHERE description LIKE ‘%%%s%%’ OR filename LIKE ‘%%%s%%’ OR uploader LIKE ‘%%%s%%’ ORDER BY fileid DESC” % (search, search, search)