Change Data with PyMySQL Package


How to make data changes to MySQL database with PyMySQL package?



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,, that creates a new table, insert a new row of data and commit the changes.

# Copyright (c) 

import pymysql
con = pymysql.connect(host="", port=3306, \
  user="guest", password="retneciyf")

sql = "CREATE TABLE fyi_sites (id INTEGER PRIMARY KEY, \
  url VARCHAR(80) NOT NULL, title VARCHAR(1024))"

sql = "INSERT INTO fyi_sites (id, url, title) \
  VALUES (101, '', 'Developer FYI')"


2. Run the Python script.

fyicenter> python3 

3. Check the result with the "mysql" client program.

fyicenter> mysql -u guest -pretneciyf -h test

mysql> select * from fyi_sites;
| id  | url               | title         |
| 101 | | Developer FYI |
1 row in set (0.00 sec)


Cursor.execute() with PyMySQL

PyMySQL Package by

Python Modules for MySQL Database

⇑⇑ Python Tutorials

2021-09-09, 678🔥, 0💬