添加链接 注册    登录
link管理
链接快照平台
  • 输入网页链接，自动生成快照
  • 标签化管理网页链接
相关文章推荐
开朗的花生  ·  Python API使用 — ...·  2 天前    · 
风流倜傥的小笼包  ·  error when i run ...·  2 天前    · 
风流倜傥的杨桃  ·  Is there a python ...·  昨天    · 
没有腹肌的碗  ·  Anaconda使用、conda的环境管理和 ...·  2 小时前    · 
痛苦的筷子  ·  Anaconda数据分析&人工智能教程（10 ...·  2 小时前    · 
闯红灯的墨镜  ·  AMERCOAT 240·  3 周前    · 
会开车的西装  ·  地铁3号线西段通车进入倒计时-新闻中心-沈阳 ...·  3 月前    · 
傻傻的南瓜  ·  迁移 Web Service 项目到 ...·  5 月前    · 
痴情的油条  ·  [QT] ...·  6 月前    · 
坚强的围巾  ·  適用於 Microsoft 365 的 ...·  6 月前    · 
link管理  ›  Python MySQL - Insert into Table - GeeksforGeeks
linux系统 table mysql python
https://www.geeksforgeeks.org/python-mysql-insert-into-table/
暴躁的猴子
10 月前

MySQL is a Relational Database Management System (RDBMS) whereas the structured Query Language (SQL) is the language used for handling the RDBMS using commands i.e Creating, Inserting, Updating and Deleting the data from the databases. SQL commands are case insensitive i.e CREATE and create signify the same command. Note: Before we insert data into our database, we need to create a table. In order to do so, refer to Python: MySQL Create Table.

Inserting data

You can insert one row or multiple rows at once. The connector code is required to connect the commands to the particular database.

Connector query

Python3

# Enter the server name in host
# followed by your user and
# password along with the database
# name provided by you.
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost",
user = "username",
password = "password",
database = "database_name"
mycursor = mydb.cursor()

Now, the Insert into Query can be written as follows: Example: Let’s suppose the record looks like this – python-mysql-insert

Python3

Output: 

1 details inserted

python-mysql-insert-2 To insert multiple values at once, executemany() method is used. This method iterates through the sequence of parameters, passing the current parameter to the execute method. Example:

Python3

sql = "INSERT INTO Student (Name, Roll_no) VALUES ( % s, % s)"
val = [("Akash", " 98 "),
("Neel", " 23 "),
("Rohan", " 43 "),
("Amit", " 87 "),
("Anil", " 45 "),
("Megha", " 55 "),
("Sita", " 95 ")]
mycursor.executemany(sql, val)
mydb.commit()
print (mycursor.rowcount, "details inserted")
# disconnecting from server
mydb.close()
  • The cursor() is used in order to iterate through the rows.
  • Without the command mydb.commit() the changes will not be saved.

    • Python program that inserts a row into a MySQL table using the mysql-connector library:

    Python

    # Prepare the SQL query
    sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
    values = ( "John Smith" , "123 Main St" )
    # Execute the query
    cursor.execute(sql, values)
    # Commit the changes
    db.commit()
    # Print the number of rows affected
    print (cursor.rowcount, "record inserted." )

    This program connects to a MySQL server and inserts a row into a table named customers with the name and address values provided. The mysql-connector library is used to interact with the MySQL server.

    The time complexity of this program depends on the efficiency of the MySQL server and the size of the table being inserted into. The execute() function is generally fast, with a time complexity of O(1), but the actual time it takes to execute the query will depend on the size and complexity of the table.

    The space complexity of this program is also O(1), as it doesn’t create any significant additional data structures beyond the values variable.

    When run, this program should output a message indicating the number of rows affected by the query, which in this case should be 1.

    We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy Got It !
    Please go through our recently updated Improvement Guidelines before submitting any improvements.
    This article is being improved by another user right now. You can suggest the changes for now and it will be under the article's discussion tab.
    You will be notified via email once the article is available for improvement. Thank you for your valuable feedback!
    Please go through our recently updated Improvement Guidelines before submitting any improvements.
    Suggest Changes
    Help us improve. Share your suggestions to enhance the article. Contribute your expertise and make a difference in the GeeksforGeeks portal.
     
    推荐文章
    开朗的花生  ·  Python API使用 — MNN-Doc 2.1.1 documentation
    2 天前
    风流倜傥的小笼包  ·  error when i run pipenv install · Issue #2470 · pypa/pipenv · GitHub
    2 天前
    风流倜傥的杨桃  ·  Is there a python library to make calls to a postgres db in a startup script? | Community
    昨天
    没有腹肌的碗  ·  Anaconda使用、conda的环境管理和包管理 - 焦距
    2 小时前
    痛苦的筷子  ·  Anaconda数据分析&人工智能教程（100讲）__bilibili
    2 小时前
    闯红灯的墨镜  ·  AMERCOAT 240
    3 周前
    会开车的西装  ·  地铁3号线西段通车进入倒计时-新闻中心-沈阳市城乡建设局
    3 月前
    傻傻的南瓜  ·  迁移 Web Service 项目到 .NET Core - 华灯-个人生活记录
    5 月前
    痴情的油条  ·  [QT] QObject::connect: Cannot queue arguments of type 'Type Name' — 개인공간
    6 月前
    坚强的围巾  ·  適用於 Microsoft 365 的 Microsoft Copilot 的功能和方案 | Microsoft 365
    6 月前
    Link管理   ·   51好读   ·   Sov5搜索   ·   小百科
    link管理 - 链接快照平台