View the code on Gist.
View the code on Gist.
conn.execute(“””insert into %s (a, b, c, d) values(%%s, %%s, %%s, %%s)””” %tablename,(a, b, c, d))
I just compiled and installed mysqldb for python 2.7 on my mac os 10.7. import MySQLdb as mysql def main(): conn = mysql.connect( charset=”utf8″, use_unicode=True, host=”localhost”,user=”root”, passwd=””,db=”” ) if __name__ == ‘__main__'(): main() When executing it I get the following error message Traceback (most recent call last): File “/path/to/project/Python/src/cvdv/TestMySQLdb.py”, line 4, in import MySQLdb as
Of the many ways to inset values into a MySQL database, we could use the below also: insert_query = “INSERT INTO %s(symbol, date,open,high,low,close,volume) VALUES( %s,%s, %s , %s , %s , %s, %s )” insert_cursor.execute(insert_query %(symbol_Nasdaq, symbol_Nasdaq, row_Nasdaq[0], row_Nasdaq[1], row_Nasdaq[2], row_Nasdaq[3], row_Nasdaq[4], volume_fin)) The above query will most likely give you an error stating the