Python-сообщество

import MySQLdb
path = r'C:\config.cnf'
db = MySQLdb.connect(read_default_file=path)
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
cursor.execute("INSERT INTO table1(Name, Alert, Date) VALUES('PC user','1', NOW())")
db.close()

cursor.execute("INSERT INTO table(Name, Alert, Date) VALUES('PC user','1', NOW())")
db.commit()

import MySQLdb
path = r'C:\config.cnf'
db = MySQLdb.connect(read_default_file=path)
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
print('{} Version MySQL'.format(cursor.fetchall()))
cursor.execute('CREATE TEMPORARY TABLE test.mysupertest(id INT(11), val VARCHAR(255))')
cursor.execute("INSERT INTO test.mysupertest(id, val) VALUES(1, 'some_value')")
cursor.execute('SELECT * FROM test.mysupertest')
print(cursor.fetchall())
cursor.execute('DROP TABLE IF EXISTS test.mysupertest')
db.close()

(('5.5.41-log',),) Version MySQL
((1, 'some_value'),)

c:\openserver\modules\database\MySQL-5.5\bin\mysqld.exe, Version: 5.5.41-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
150311 16:07:56	    1 Connect	root@localhost on 
		    1 Query	set autocommit=0
		    1 Query	SELECT VERSION()
		    1 Query	CREATE TEMPORARY TABLE test.mysupertest(id INT(11), val VARCHAR(255))
		    1 Query	INSERT INTO test.mysupertest(id, val) VALUES(1, 'some_value')
		    1 Query	SELECT * FROM test.mysupertest
		    1 Query	DROP TABLE IF EXISTS test.mysupertest
		    1 Quit

(1, 'some_value'),