Merge pull request codehouseindia#486 from mauryaankitsh/patch-5

codehouseindia · web-flow · commit 80540dc28b78 · 2020-10-10T01:41:32.000+05:30
Inserting multiple data in mysql simultaneously
diff --git a/Inertingmultipledatainmysql.py b/Inertingmultipledatainmysql.py
@@ -0,0 +1,29 @@
+import mysql.connector
+from mysql.connector import Error
+
+try:
+    connection = mysql.connector.connect(host='localhost',
+                                         database='Electronics',
+                                         user='pynative',
+                                         password='pynative@#29')
+
+    mySql_insert_query = """INSERT INTO Laptop (Id, Name, Price, Purchase_date) 
+                           VALUES (%s, %s, %s, %s) """
+
+    records_to_insert = [(4, 'HP Pavilion Power', 1999, '2019-01-11'),
+                         (5, 'MSI WS75 9TL-496', 5799, '2019-02-27'),
+                         (6, 'Microsoft Surface', 2330, '2019-07-23')]
+
+    cursor = connection.cursor()
+    cursor.executemany(mySql_insert_query, records_to_insert)
+    connection.commit()
+    print(cursor.rowcount, "Record inserted successfully into Laptop table")
+
+except mysql.connector.Error as error:
+    print("Failed to insert record into MySQL table {}".format(error))
+
+finally:
+    if (connection.is_connected()):
+        cursor.close()
+        connection.close()
+        print("MySQL connection is closed")
