python mysql

https://www.youtube.com/watch?v=B956r7XzJIA 

pip install pymysql

db.py--------------------

import pymysql
# connect
db = pymysql.connect(
                        host="localhost",
                        user="root",
                        password="1234",
                        charset="utf8"
                    )
cursor = db.cursor(pymysql.cursors.DictCursor)
cursor.execute('USE helloworld;')
# CREATE
# cursor.execute('INSERT INTO lang (name, description, study) VALUES ("Java", "Java is for programming..", FALSE)')
# READ
# cursor.execute('SELECT * FROM lang;')
# value = cursor.fetchall()
# print(value)
# print(value[0]["description"])
# UPDATE
# cursor.execute('UPDATE lang SET description="HTML is the form web" WHERE name="HTML"')
# DELETE
# cursor.execute('DELETE FROM lang WHERE name="Java"')
db.commit()
db.close()

====================

https://www.youtube.com/watch?v=bi9hg5FPi5Y