Tools, FAQ, Tutorials:
Change Data with PyMySQL Package
How to make data changes to MySQL database with PyMySQL package?
✍: FYIcenter.com
Making data changes to MySQL database with PyMySQL package
requires to run INSERT, UPDATE or DELETE SQL statements
with an established connection.
By default, changes are not committed until you call the con.commit() method explicitly.
1. Create is a sample Python script, PyMySQL_insert_data.py, that creates a new table, insert a new row of data and commit the changes.
# PyMySQL_insert_data.py # Copyright (c) FYIcenter.com import pymysql con = pymysql.connect(host="127.0.0.1", port=3306, \ user="guest", password="retneciyf") con.select_db("test") sql = "CREATE TABLE fyi_sites (id INTEGER PRIMARY KEY, \ url VARCHAR(80) NOT NULL, title VARCHAR(1024))" con.query(sql) sql = "INSERT INTO fyi_sites (id, url, title) \ VALUES (101, 'dev.fyicenter.com', 'Developer FYI')" con.query(sql) con.commit() con.close()
2. Run the Python script.
fyicenter> python3 PyMySQL_insert_data.py
3. Check the result with the "mysql" client program.
fyicenter> mysql -u guest -pretneciyf -h 127.0.0.1 test mysql> select * from fyi_sites; +-----+-------------------+---------------+ | id | url | title | +-----+-------------------+---------------+ | 101 | dev.fyicenter.com | Developer FYI | +-----+-------------------+---------------+ 1 row in set (0.00 sec)
⇒ Cursor.execute() with PyMySQL
2021-09-09, 948🔥, 0💬
Popular Posts:
FYIcenter.com Online Tools: FYIcenter JSON Validator and Formatter FYIcenter JSON to XML Converter F...
dev.FYIcenter.com is a Website for software developer looking for software development technologies,...
How to add request URL Template Parameters to my Azure API operation 2017 version to make it more us...
Where to find tutorials on Microsoft Azure services? Here is a large collection of tutorials to answ...
How to use the urllib.request.Request object to build more complex HTTP request? The urllib.request....