Merge pull request codehouseindia#485 from mauryaankitsh/patch-4

codehouseindia · web-flow · commit 559949e042f2 · 2020-10-10T01:41:40.000+05:30
By this we can insert data in mysql
diff --git a/InsertingRecordinmysqlwithpython.py b/InsertingRecordinmysqlwithpython.py
@@ -0,0 +1,27 @@
+import mysql.connector
+from mysql.connector import Error
+from mysql.connector import errorcode
+
+try:
+    connection = mysql.connector.connect(host='localhost',
+                                         database='electronics',
+                                         user='root',
+                                         password='pynative@#29')
+    mySql_insert_query = """INSERT INTO Laptop (Id, Name, Price, Purchase_date) 
+                           VALUES 
+                           (10, 'Lenovo ThinkPad P71', 6459, '2019-08-14') """
+
+    cursor = connection.cursor()
+    cursor.execute(mySql_insert_query)
+    connection.commit()
+    print(cursor.rowcount, "Record inserted successfully into Laptop table")
+    cursor.close()
+
+except mysql.connector.Error as error:
+    print("Failed to insert record into Laptop table {}".format(error))
+
+finally:
+    if (connection.is_connected()):
+        connection.close()
+        print("MySQL connection is closed")
+
