树莓派 python mysql_RaspberryPi4B树莓派4B，Python3与MySQL或者mariadb数据库交互

#!/usr/bin/python3

import MySQLdb

conn = MySQLdb.connect(host='localhost', user='test', passwd='test', db='pyytest', port=3306)

cursor = conn.cursor()

newemployee = ('INSERT INTO employees '

'(empid, lastname, firstname, salary) '

'VALUES (%s, %s, %s, %s)')

employee1 = ('1', 'Tony', 'Barbare', '5432.1')

employee2 = ('2', 'Sara', 'Rich', '9876.5')

employee3 = ('3', 'H', 'Yuan', '3562.45')

employee4 = ('4', 'J', 'Yang', '5689.78')

try:

cursor.execute(newemployee, employee1)

cursor.execute(newemployee, employee2)

cursor.execute(newemployee, employee3)

cursor.execute(newemployee, employee4)

conn.commit()

except:

print('Sorry, there was a problem adding the data')

else:

print('Data values added!')

cursor.close()

conn.close()