Tools, FAQ, Tutorials:
Change Data with "mysql.connector"
How to make data changes to MySQL database with "mysql.connector" module?
✍: FYIcenter.com
Making data changes to MySQL database with "mysql.connector"
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, insert_data.py, that creates a new table, insert a new row of data and commit the changes.
# insert_data.py # Copyright (c) FYIcenter.com from mysql.connector import connect con = connect(host="127.0.0.1", port=3306, \ user="guest", password="retneciyf") con.cmd_init_db("test") sql = "CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, \ url VARCHAR(80) NOT NULL, title VARCHAR(1024))" con.cmd_query(sql) sql = "INSERT INTO fyi_links (id, url, title) \ VALUES (101, 'dev.fyicenter.com', 'Developer FYI')" con.cmd_query(sql) con.commit() con.close()
2. Run the Python script.
fyicenter> python3 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_links; +-----+-------------------+---------------+ | id | url | title | +-----+-------------------+---------------+ | 101 | dev.fyicenter.com | Developer FYI | +-----+-------------------+---------------+ 1 row in set (0.00 sec)
⇒ Handle Exceptions with "mysql.connector"
⇐ "mysql.connector" Module by mysql.com
2021-09-09, 644👍, 0💬
Popular Posts:
How to Build my "sleep" Docker image from the Alpine image? I want the container to sleep for 10 hou...
How to read Atom validation errors at w3.org? If your Atom feed has errors, the Atom validator at w3...
Where to get the detailed description of the json_encode() Function in PHP? Here is the detailed des...
How To Read Data from Keyboard (Standard Input) in PHP? If you want to read data from the standard i...
Can Two Forms Be Nested? Can two forms be nested? The answer is no and yes: No. You can not nest two...