Pycharm2017 realizes the connection between python3.6 and mysql

import pymysql
 
#Establish database connection conn=pymysql.Connect(
 host='localhost',
 port=3306,
 user='root',
 passwd='database password',
 db='bigsdut',
 charset='utf8'
)
 
#Get the cursor cursor=conn.cursor()
#print(conn)
#print(cursor)
 
#1. Query from the database #sql="INSERT INTO login(user_name,pass_word)"
sql="SELECT *FROM login"
#cursor executes the sql statement cursor.execute(sql)
#Print the number of execution results print(cursor.rowcount)
 
#Use the fetch method to traverse the results. There are three data in total. #rs=cursor.fetchone()#Put the first result in rs#re=cursor.fetchmany(3)#Put multiple results in rerr=cursor.fetchall()#Put all results in rr#Process the results for row in rr:
 print("ID is: =%s, name is: =%s, password is: =%s"%row)
#print(re)#Output two pieces of data, because the fetch() method is based on the previous fetch() method #2 Insert data into the database sql_insert="INSERT INTO login(user_name,pass_word) values('Zhongxing','123')"
#Execute statement cursor.execute(sql_insert)
#Transaction commit, otherwise the database will not be updated conn.commit()
print(cursor.rowcount)
 
 
#Modify the content in the database sql_update="UPDATE login SET user_name='hhh' WHERE id=3"
cursor.execute(sql_update)
conn.commit()
 
#Delete the content in the database and use the try catch statement to roll back the transaction try:
 sql_delete="DELETE FROM login WHERE id=6"
 cursor.execute(sql_delete)
 conn.commit()
except Exception as e:
 print (e)
 #Transaction rollback, that is, after an error occurs, the program will not continue to execute, but will return to the state where the program has not been executed, and the original execution will not be counted conn.rollback()
 
 
 
#Closing the database connection and cursor conn.close()
cursor.close()