import MySQLdb
conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database_name')
conn.close()
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database_name')
cursor = conn.cursor()
cursor.execute('SELECT * FROM table_name')
results = cursor.fetchall()
for row in results:
print(row)
cursor.close()
conn.close()
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database_name')
try:
conn.begin()
cursor = conn.cursor()
cursor.execute('INSERT INTO table_name (column1, column2) VALUES (%s, %s)', ('value1', 'value2'))
conn.commit()
cursor.close()
except Exception as e:
conn.rollback()
print(str(e))
finally:
conn.close()
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database_name')
cursor = conn.cursor()
cursor.execute('SELECT * FROM table_name')
result = cursor.fetchone()
print(result)
cursor.execute('UPDATE table_name SET column1 = %s WHERE id = %s', ('new_value', 1))
conn.commit()
cursor.close()
conn.close()
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database_name')
cursor = conn.cursor()
data = [('value1', 'value2'), ('value3', 'value4'), ('value5', 'value6')]
cursor.executemany('INSERT INTO table_name (column1, column2) VALUES (%s, %s)', data)
conn.commit()
cursor.close()
conn.close()
