Python
Insert data into MySQL table using Python.
Insert data into MySQL table using Python.
Install mysqlclient
Open Terminal or Cmd
cd ~/your-rpoject-folder
virtualenv env
source env/bin/activate
pip install mysql-python
pip install mysqlclient
Then connect your database and insert data
page.py
import mysql.connector
con=mysql.connector.connect(
host="localhost",
user="root",
passwd="",
database = "Your database"
)
cursorT=con.cursor();
email="Dipankar"
upass="12345"
query = "INSERT INTO test1 (uname, upass) VALUES (%s, %s)"
values = (email,upass)
cursorT.execute(query, values)
con.commit()
Run this page
run ~/Desktop/PC_SYSTEM$ python3 page.py
Recent Post
Related Post
-
No module named PIL
Post : Python 05-05-2023
No module named PIL Install PIL module: If you haven't installed PIL yet, install it using pip, the..
-
Advance python Lambda function
Post : Python 28-04-2023
Lambda is a small and anonymous function in Python, where you can use many arguments but only ..
-
Connect with mysql database using python
Post : Python 21-04-2023
Connect with mysql database using python Install the mysql-connector-python-rf - $..
-
Insert data into MySQL table using Python.
Post : Python 21-04-2023
Insert data into MySQL table using Python. Install mysqlclient Open Terminal..
subscribe to our newsletter
Get the latest news and updates by signing up to our daily newsletter.We won't sell your email or spam you !