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, 944🔥, 0💬
Popular Posts:
How to use the JSON to XML Conversion Tool at freeformatter.com? If you want to try the JSON to XML ...
How to access Request body from "context.Request.Body" object in Azure API Policy? Request body is t...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....
How to Install Docker Desktop 2.5.0 on Windows 10? You can follow this tutorial to Install Docker De...
Where to find tutorials on Visual Studio? I want to know How to learn Visual Studio. Here is a large...