mysql-python

As the whole query needs to be in a string format while execution of query so %s should be used… After query is executed integer value is retained. So your line should be. .execute(“INSERT INTO table VALUES(%s,%s)”, (int(id), string)) Explanation is here

itemBank = [] for row in rows: itemBank.append(( tempRow2[‘Item_Name’], tempRow1[‘Item_Price’], tempRow3[‘Item_In_Stock’], tempRow4[‘Item_Max’], getTimeExtra )) #append data q = “”” insert ignore into TABLE1 ( Item_Name, Item_Price, Item_In_Stock, Item_Max, Observation_Date ) values (%s,%s,%s,%s,%s) “”” try: x.executemany(q, itemBank) conn.commit() except: conn.rollback() Hope it will help you

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 would create a stored procedure: DROP PROCEDURE IF EXISTS CopyTable; DELIMITER $$ CREATE PROCEDURE CopyTable(IN _mytable VARCHAR(64), _table_name VARCHAR(64)) BEGIN SET FOREIGN_KEY_CHECKS=0; SET @stmt = CONCAT(‘DROP TABLE IF EXISTS ‘,_table_name); PREPARE stmt1 FROM @stmt; EXECUTE stmt1; SET FOREIGN_KEY_CHECKS=1; SET @stmt = CONCAT(‘CREATE TABLE ‘,_table_name,’ as select * from ‘, _mytable); PREPARE stmt1 FROM @stmt; … Read more