{"id":182,"date":"2018-07-01T21:15:14","date_gmt":"2018-07-01T15:45:14","guid":{"rendered":"https:\/\/pynative.com\/?p=182"},"modified":"2021-03-09T11:02:57","modified_gmt":"2021-03-09T05:32:57","slug":"python-mysql-delete-data","status":"publish","type":"post","link":"https:\/\/pynative.com\/python-mysql-delete-data\/","title":{"rendered":"Python Delete data from MySQL Table"},"content":{"rendered":"\n<p>This lesson demonstrates how to execute the <strong>SQL DELETE query from Python<\/strong> to delete data from a MySQL database table. <\/p>\n\n\n\n<p>After reading this article, you will able to delete single, multiple, and all rows, as well as delete a single column and multiple columns from the MySQL table using Python<\/p>\n\n\n\n<div class=\"wp-block-columns sectionpy has-black-color has-text-color has-background is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\" style=\"background-color:#fff7ed\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Further Reading<\/strong>:<\/p>\n\n\n\n<ul><li>Solve&nbsp;<a href=\"https:\/\/pynative.com\/python-database-programming-exercise-with-solution\/\">Python MySQL Exercise<\/a><\/li><li>Read&nbsp;<a href=\"https:\/\/pynative.com\/python-mysql-database-connection\/\">Python MySQL Tutorial (Complete Guide)<\/a><\/li><\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-yoast-seo-table-of-contents yoast-table-of-contents\"><h2>Table of contents<\/h2><ul><li><a href=\"#h-prerequisites\" data-level=\"2\">Prerequisites<\/a><\/li><li><a href=\"#h-python-example-to-delete-a-single-row-from-a-mysql-table\" data-level=\"2\">Python Example to Delete a Single Row from a MySQL table<\/a><\/li><li><a href=\"#h-use-python-variable-in-a-sql-query-to-delete-data-from-the-table\" data-level=\"2\">Use Python Variable in a SQL query to delete data from the table<\/a><\/li><li><a href=\"#h-python-delete-multiple-rows-from-a-mysql-table\" data-level=\"2\">Python Delete Multiple Rows from a MySQL Table<\/a><\/li><li><a href=\"#h-delete-all-rows-from-a-table-in-python\" data-level=\"2\">Delete All rows from a table in Python<\/a><\/li><li><a href=\"#h-delete-mysql-table-and-database-from-python\" data-level=\"2\">Delete MySQL Table and Database from Python<\/a><\/li><li><a href=\"#h-delete-mysql-table-column-from-python\" data-level=\"2\">Delete MySQL Table column from Python<\/a><\/li><li><a href=\"#h-next-steps\" data-level=\"2\">Next Steps<\/a><\/li><\/ul><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-prerequisites\">Prerequisites<\/h2>\n\n\n\n<p>Before moving further, Please make sure you have the following in place: \u2013<\/p>\n\n\n\n<ul><li>Username and password to connect MySQL<\/li><li>MySQL table name in which you want to insert data.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-2 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p>To perform a delete operation, I am using a Laptop table present in my MySQL server.<\/p>\n\n\n\n<p>If a table is not present in your MySQL server, you can refer to our article to <a href=\"https:\/\/pynative.com\/python-mysql-database-connection\/#h-create-mysql-table-from-python\">create a MySQL table from Python<\/a>.<\/p>\n\n\n\n<p>You can also download a <a href=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/laptop_table_creation_with_data.txt\">SQL query file<\/a>, which contains SQL queries for table creation and data so that you can use this table for your INSERT operations.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"451\" height=\"300\" src=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_with_data.png\" alt=\"MySQL Laptop table with data\" class=\"wp-image-4515\" srcset=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_with_data.png 451w, https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_with_data-300x200.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><figcaption>MySQL Laptop table with data<\/figcaption><\/figure><\/div>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-python-example-to-delete-a-single-row-from-a-mysql-table\">Python Example to Delete a Single Row from a MySQL table<\/h2>\n\n\n\n<p><strong>Follow these steps: &#8211;<\/strong><\/p>\n\n\n\n<div class=\"schema-how-to wp-block-yoast-how-to-block\"><p class=\"schema-how-to-description\">How to delete a row in MySQL using Python<\/p> <ol class=\"schema-how-to-steps\"><li class=\"schema-how-to-step\" id=\"how-to-step-1613854588396\"><strong class=\"schema-how-to-step-name\">Connect to MySQL from Python<\/strong> <p class=\"schema-how-to-step-text\">Refer to <a href=\"https:\/\/pynative.com\/python-mysql-database-connection\/\">Python MySQL database connection<\/a> to connect to MySQL database from Python using MySQL Connector module<\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613854736175\"><strong class=\"schema-how-to-step-name\">Define a SQL Delete Query<\/strong> <p class=\"schema-how-to-step-text\">Next, prepare a SQL delete query to delete a row from a table. Delete query contains the row to be deleted based on a condition placed in where clause of a query.<br\/>For example, <code>DELETE FROM MySQL_table WHERE id=10;<\/code><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613884793763\"><strong class=\"schema-how-to-step-name\">Get Cursor Object from Connection <\/strong> <p class=\"schema-how-to-step-text\">Next, use a <code>connection.cursor()<\/code> method to create a cursor object. This method creates a new <code>MySQLCursor<\/code> object.<\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613855028385\"><strong class=\"schema-how-to-step-name\">Execute the delete query using execute() method<\/strong> <p class=\"schema-how-to-step-text\">Execute the delete query using the <code>cursor.execute()<\/code> method. This method executes the operation stored in the delete query. <br\/>After a successful delete operation, the <code>execute()<\/code> method returns us the number of rows affected.<\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613855113883\"><strong class=\"schema-how-to-step-name\">Commit your changes<\/strong> <p class=\"schema-how-to-step-text\">After successfully executing a delete operation, make changes persistent into a database using the <code>commit()<\/code> of a connection class.<\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613855284036\"><strong class=\"schema-how-to-step-name\">Get the number of rows affected<\/strong> <p class=\"schema-how-to-step-text\">Use a <code>cursor.rowcount<\/code> method to get the number of rows affected. The count depends on how many rows you are deleting. <br\/>You can also <a href=\"https:\/\/pynative.com\/python-mysql-select-query-to-fetch-data\/\">Execute a MySQL select query from Python<\/a> to Verify the result.<\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613855485727\"><strong class=\"schema-how-to-step-name\">Close the cursor object and database connection object<\/strong> <p class=\"schema-how-to-step-text\">use <code>cursor.clsoe()<\/code> and <code>connection.clsoe()<\/code> method to close open connections after your work completes.<\/p> <\/li><\/ol><\/div>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"666\" height=\"406\" src=\"https:\/\/pynative.com\/wp-content\/uploads\/2018\/12\/python_delete_from_mysql_table.png\" alt=\"python delete data from MySQL table\" class=\"wp-image-1207\" srcset=\"https:\/\/pynative.com\/wp-content\/uploads\/2018\/12\/python_delete_from_mysql_table.png 666w, https:\/\/pynative.com\/wp-content\/uploads\/2018\/12\/python_delete_from_mysql_table-300x183.png 300w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><figcaption>python delete data from MySQL table<\/figcaption><\/figure><\/div>\n\n\n\n<p><strong>Example<\/strong><\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code1\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> mysql.connector\n\n<span class=\"hljs-keyword\">try<\/span>:\n    connection = mysql.connector.connect(host=<span class=\"hljs-string\">'localhost'<\/span>,\n                                         database=<span class=\"hljs-string\">'electronics'<\/span>,\n                                         user=<span class=\"hljs-string\">'root'<\/span>)\n    cursor = connection.cursor()\n    print(<span class=\"hljs-string\">\"Laptop table before deleting a row\"<\/span>)\n    sql_select_query = <span class=\"hljs-string\">\"\"\"select * from Laptop where id = 7\"\"\"<\/span>\n    cursor.execute(sql_select_query)\n    record = cursor.fetchone()\n    print(record)\n\n    <span class=\"hljs-comment\"># Delete a record<\/span>\n    sql_Delete_query = <span class=\"hljs-string\">\"\"\"Delete from Laptop where id = 7\"\"\"<\/span>\n    cursor.execute(sql_Delete_query)\n    connection.commit()\n    print(<span class=\"hljs-string\">'number of rows deleted'<\/span>, cursor.rowcount)\n\n    <span class=\"hljs-comment\"># Verify using select query (optional)<\/span>\n    cursor.execute(sql_select_query)\n    records = cursor.fetchall()\n    <span class=\"hljs-keyword\">if<\/span> len(records) == <span class=\"hljs-number\">0<\/span>:\n        print(<span class=\"hljs-string\">\"Record Deleted successfully \"<\/span>)\n\n<span class=\"hljs-keyword\">except<\/span> mysql.connector.Error <span class=\"hljs-keyword\">as<\/span> error:\n    print(<span class=\"hljs-string\">\"Failed to delete record from table: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        cursor.close()\n        connection.close()\n        print(<span class=\"hljs-string\">\"MySQL connection is closed\"<\/span>)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code1', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p><strong>Output<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Displaying laptop record Before Deleting it\n(7, 'Acer Predator Triton', 2435.0, datetime.date(2019, 8, 17))\n\nRecord Deleted successfully \nMySQL connection is closed<\/pre>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"454\" height=\"254\" src=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_deleting_record.png\" alt=\"MySQL Laptop table after deleting record\" class=\"wp-image-4573\" srcset=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_deleting_record.png 454w, https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_deleting_record-300x168.png 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/><figcaption>MySQL Laptop table after deleting record<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-use-python-variable-in-a-sql-query-to-delete-data-from-the-table\">Use Python Variable in a SQL query to delete data from the table<\/h2>\n\n\n\n<p>Sometimes we need input from the user, for example, when the user is deleting their data from the web portal or any other details through User Interface. in such a scenario, it is always best practice to use a parameterized query.<\/p>\n\n\n\n<p>A prepared statement or <strong>parameterized query uses placeholders (<code>%s<\/code> )<\/strong> inside any SQL statements that contain input from users. i.e., Using a <a href=\"https:\/\/pynative.com\/python-mysql-execute-parameterized-query-using-prepared-statement\/\">parameterized query<\/a>, we can pass Python variables as a query parameter in which placeholders (<code>%s<\/code>) used for parameters.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code2\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> mysql.connector\n\n<span class=\"hljs-keyword\">try<\/span>:\n    connection = mysql.connector.connect(host=<span class=\"hljs-string\">'localhost'<\/span>,\n                                         database=<span class=\"hljs-string\">'electronics'<\/span>,\n                                         user=<span class=\"hljs-string\">'pynative'<\/span>,\n                                         password=<span class=\"hljs-string\">'pynative@#29'<\/span>)\n    cursor = connection.cursor()\n    sql_Delete_query = <span class=\"hljs-string\">\"\"\"Delete from Laptop where id = %s\"\"\"<\/span>\n    <span class=\"hljs-comment\"># row to delete<\/span>\n    laptopId = <span class=\"hljs-number\">6<\/span>\n    cursor.execute(sql_Delete_query, (laptopId,))\n    connection.commit()\n    print(<span class=\"hljs-string\">\"Record Deleted successfully \"<\/span>)\n\n<span class=\"hljs-keyword\">except<\/span> mysql.connector.Error <span class=\"hljs-keyword\">as<\/span> error:\n    print(<span class=\"hljs-string\">\"Failed to Delete record from table: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        cursor.close()\n        connection.close()\n        print(<span class=\"hljs-string\">\"MySQL connection is closed\"<\/span>)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code2', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Record Deleted successfully \nMySQL connection is closed<\/pre>\n\n\n\n<p><strong>Note<\/strong>: We defined SQL delete query with placeholder which contains Laptop <strong>Id to delete in tuple format<\/strong>. Refer to Select query to fetch data from MySQL table to verify your delete operation result.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-python-delete-multiple-rows-from-a-mysql-table\">Python Delete Multiple Rows from a MySQL Table<\/h2>\n\n\n\n<p>Sometimes we need to delete an <strong>N-number of rows that match a specific condition<\/strong>. For example, you want to delete employee data from the employee table who left the organization. You can delete multiple rows from the MySQL table using a single delete SQL Query in Python.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code3\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> mysql.connector\n\n<span class=\"hljs-keyword\">try<\/span>:\n    connection = mysql.connector.connect(host=<span class=\"hljs-string\">'localhost'<\/span>,\n                                         database=<span class=\"hljs-string\">'electronics'<\/span>,\n                                         user=<span class=\"hljs-string\">'pynative'<\/span>,\n                                         password=<span class=\"hljs-string\">'pynative@#29'<\/span>)\n\n    cursor = connection.cursor()\n    sql_Delete_query = <span class=\"hljs-string\">\"\"\"Delete from Laptop where id = %s\"\"\"<\/span>\n    records_to_delete = &#91;(<span class=\"hljs-number\">6<\/span>,), (<span class=\"hljs-number\">5<\/span>,)]\n    cursor.executemany(sql_Delete_query, records_to_delete)\n    connection.commit()\n    print(cursor.rowcount, <span class=\"hljs-string\">\" Record Deleted successfully\"<\/span>)\n\n<span class=\"hljs-keyword\">except<\/span> mysql.connector.Error <span class=\"hljs-keyword\">as<\/span> error:\n    print(<span class=\"hljs-string\">\"Failed to Delete records from MySQL table: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        cursor.close()\n        connection.close()\n        print(<span class=\"hljs-string\">\"MySQL connection is closed\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code3', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">2 Record Deleted successfully \nMySQL connection is closed<\/pre>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"451\" height=\"187\" src=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_deleting_multiplr_records.png\" alt=\"MySQL Laptop table after deleting multiple records\" class=\"wp-image-4572\" srcset=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_deleting_multiplr_records.png 451w, https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_deleting_multiplr_records-300x124.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><figcaption>MySQL Laptop table after deleting multiple records<\/figcaption><\/figure><\/div>\n\n\n\n<p>Refer to Select query to fetch data from MySQL table to verify your delete operation result.<\/p>\n\n\n\n<p><strong>Let&#8217;s&nbsp; understand the above program<\/strong>: &#8211;<\/p>\n\n\n\n<ul><li>We defined SQL delete query with placeholder which contains Laptop IDs to delete in a list format. This List contains a tuple for each row. Here we created two tuples, so we are deleting two rows.<\/li><li>Next, we used the <strong>cursor&#8217;s <code>executemany()<\/code><\/strong> method to delete multiple rows of a database table. Using a <code>cursor.rowcount<\/code> method, we can find how many rows were deleted successfully.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-delete-all-rows-from-a-table-in-python\">Delete All rows from a table in Python<\/h2>\n\n\n\n<p>It is possible to delete all rows from a MySQL database table using a truncate SQL query. Truncate SQL queries remove all data from a table, typically bypassing the number of integrity enforcing mechanisms. <\/p>\n\n\n\n<p>You can refer to the Wikipedia article to read more on SQL truncate. Let&#8217;s move to python code to delete all rows from the MySQL table.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code4\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> mysql.connector\n\n<span class=\"hljs-keyword\">try<\/span>:\n    connection = mysql.connector.connect(host=<span class=\"hljs-string\">'localhost'<\/span>,\n                                         database=<span class=\"hljs-string\">'electronics'<\/span>,\n                                         user=<span class=\"hljs-string\">'pynative'<\/span>,\n                                         password=<span class=\"hljs-string\">'pynative@#29'<\/span>)\n    cursor = connection.cursor()\n    Delete_all_rows = <span class=\"hljs-string\">\"\"\"truncate table Laptop \"\"\"<\/span>\n    cursor.execute(Delete_all_rows)\n    connection.commit()\n    print(<span class=\"hljs-string\">\"All Record Deleted successfully \"<\/span>)\n\n<span class=\"hljs-keyword\">except<\/span> mysql.connector.Error <span class=\"hljs-keyword\">as<\/span> error:\n    print(<span class=\"hljs-string\">\"Failed to Delete all records from database table: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        cursor.close()\n        connection.close()\n        print(<span class=\"hljs-string\">\"MySQL connection is closed\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code4', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p><strong>Output<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">All Record Deleted successfully \nMySQL connection is closed<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-delete-mysql-table-and-database-from-python\">Delete MySQL Table and Database from Python<\/h2>\n\n\n\n<p>You can delete old, unused tables and temporary databases and tables using a DROP TABLE and DROP DATABASE statement. Let see the demo.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code5\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> mysql.connector\n\n<span class=\"hljs-keyword\">try<\/span>:\n    connection = mysql.connector.connect(host=<span class=\"hljs-string\">'localhost'<\/span>,\n                                         database=<span class=\"hljs-string\">'electronics'<\/span>,\n                                         user=<span class=\"hljs-string\">'pynative'<\/span>,\n                                         password=<span class=\"hljs-string\">'pynative@#29'<\/span>)\n    cursor = connection.cursor()\n    delete_table_query = <span class=\"hljs-string\">\"\"\"DROP TABLE Laptop\"\"\"<\/span>\n    cursor.execute(delete_table_query)\n\n    delete_database_query = <span class=\"hljs-string\">\"\"\"DROP DATABASE Electronics\"\"\"<\/span>\n    cursor.execute(delete_database_query)\n    connection.commit()\n    print(<span class=\"hljs-string\">\"Table and Database Deleted successfully \"<\/span>)\n\n<span class=\"hljs-keyword\">except<\/span> mysql.connector.Error <span class=\"hljs-keyword\">as<\/span> error:\n    print(<span class=\"hljs-string\">\"Failed to Delete table and database: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        cursor.close()\n        connection.close()\n        print(<span class=\"hljs-string\">\"MySQL connection is closed\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code5', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p><strong>Output<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Table and Database Deleted successfully \nMySQL connection is closed<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-delete-mysql-table-column-from-python\">Delete MySQL Table column from Python<\/h2>\n\n\n\n<p>Use alter table drop column command to delete a column from a MySQL table.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code6\"  id=\"norun\" class=\"wp-block-code language-python\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"Python\" data-shcb-language-slug=\"python\"><span><code class=\"hljs language-python\"><span class=\"hljs-keyword\">import<\/span> mysql.connector\n\n<span class=\"hljs-keyword\">try<\/span>:\n    connection = mysql.connector.connect(host=<span class=\"hljs-string\">'localhost'<\/span>,\n                                         database=<span class=\"hljs-string\">'electronics'<\/span>,\n                                         user=<span class=\"hljs-string\">'pynative'<\/span>,\n                                         password=<span class=\"hljs-string\">'pynative@#29'<\/span>)\n    cursor = connection.cursor()\n    alter_column = <span class=\"hljs-string\">\"\"\"ALTER TABLE Laptop DROP COLUMN Purchase_date\"\"\"<\/span>\n    cursor.execute(alter_column)\n    connection.commit()\n    print(<span class=\"hljs-string\">\"Column Deleted successfully \"<\/span>)\n\n<span class=\"hljs-keyword\">except<\/span> mysql.connector.Error <span class=\"hljs-keyword\">as<\/span> error:\n    print(<span class=\"hljs-string\">\"Failed to Delete column: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        cursor.close()\n        connection.close()\n        print(<span class=\"hljs-string\">\"MySQL connection is closed\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">Python<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">python<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><button class=\"hljs-copy-button\" onclick=\"copy_code('code6', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p><strong>Output<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Column Deleted successfully \nMySQL connection is closed<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-next-steps\">Next Steps<\/h2>\n\n\n\n<p>To practice what you learned in this article, Please solve a&nbsp;<a href=\"https:\/\/pynative.com\/python-database-programming-exercise-with-solution\/\">Python Database Exercise project<\/a>&nbsp;to Practice and master the Python Database operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This lesson demonstrates how to execute the SQL DELETE query from Python to delete data from a MySQL database table. After reading this article, you will able to delete single, multiple, and all rows, as well as delete a single column and multiple columns from the MySQL table using Python Further Reading: Solve&nbsp;Python MySQL Exercise [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2085,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[22,23],"tags":[25],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.4 (Yoast SEO v22.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python MySQL Delete table Data [Complete Guide]<\/title>\n<meta name=\"description\" content=\"Python MySQL delete query to delete single row, multiple rows, all rows, single column and multiple columns of a Delete table and database. use python varible in delete query.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pynative.com\/python-mysql-delete-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python Delete data from MySQL Table\" \/>\n<meta property=\"og:description\" content=\"Python MySQL delete query to delete single row, multiple rows, all rows, single column and multiple columns of a Delete table and database. use python varible in delete query.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pynative.com\/python-mysql-delete-data\/\" \/>\n<meta property=\"og:site_name\" content=\"PYnative\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-01T15:45:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-09T05:32:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png\" \/>\n\t<meta property=\"og:image:width\" content=\"295\" \/>\n\t<meta property=\"og:image:height\" content=\"235\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PyNative\" \/>\n<meta name=\"twitter:site\" content=\"@PyNative\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/\"},\"author\":{\"name\":\"Vishal\",\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"headline\":\"Python Delete data from MySQL Table\",\"datePublished\":\"2018-07-01T15:45:14+00:00\",\"dateModified\":\"2021-03-09T05:32:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/\"},\"wordCount\":892,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"image\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png\",\"keywords\":[\"Python MySQL\"],\"articleSection\":[\"Python\",\"Python Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/pynative.com\/python-mysql-delete-data\/#respond\"]}],\"accessibilityFeature\":[\"tableOfContents\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/\",\"name\":\"Python MySQL Delete table Data [Complete Guide]\",\"isPartOf\":{\"@id\":\"https:\/\/pynative.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png\",\"datePublished\":\"2018-07-01T15:45:14+00:00\",\"dateModified\":\"2021-03-09T05:32:57+00:00\",\"description\":\"Python MySQL delete query to delete single row, multiple rows, all rows, single column and multiple columns of a Delete table and database. use python varible in delete query.\",\"breadcrumb\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pynative.com\/python-mysql-delete-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage\",\"url\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png\",\"contentUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png\",\"width\":295,\"height\":235,\"caption\":\"Python MySQL Delete Data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pynative.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python\",\"item\":\"https:\/\/pynative.com\/python\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Databases\",\"item\":\"https:\/\/pynative.com\/python\/databases\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Python Delete data from MySQL Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pynative.com\/#website\",\"url\":\"https:\/\/pynative.com\/\",\"name\":\"PYnative\",\"description\":\"Python Programming\",\"publisher\":{\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pynative.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\",\"name\":\"Vishal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg\",\"contentUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg\",\"width\":968,\"height\":1065,\"caption\":\"Vishal\"},\"logo\":{\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/image\/\"},\"description\":\"Founder of PYnative.com. I am a Python developer and I love to write articles to help developers. | All the best for your future Python endeavors!\",\"sameAs\":[\"https:\/\/pynative.com\"]},{\"@type\":\"HowTo\",\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#howto-1\",\"name\":\"Python Delete data from MySQL Table\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#article\"},\"description\":\"How to delete a row in MySQL using Python\",\"step\":[{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613854588396\",\"name\":\"Connect to MySQL from Python\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Refer to <a href=\\\"https:\/\/pynative.com\/python-mysql-database-connection\/\\\">Python MySQL database connection<\/a> to connect to MySQL database from Python using MySQL Connector module\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613854736175\",\"name\":\"Define a SQL Delete Query\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Next, prepare a SQL delete query to delete a row from a table. Delete query contains the row to be deleted based on a condition placed in where clause of a query.<br\/>For example, DELETE FROM MySQL_table WHERE id=10;\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613884793763\",\"name\":\"Get Cursor Object from Connection\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Next, use a connection.cursor() method to create a cursor object. This method creates a new MySQLCursor object.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855028385\",\"name\":\"Execute the delete query using execute() method\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Execute the delete query using the cursor.execute() method. This method executes the operation stored in the delete query. <br\/>After a successful delete operation, the execute() method returns us the number of rows affected.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855113883\",\"name\":\"Commit your changes\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"After successfully executing a delete operation, make changes persistent into a database using the commit() of a connection class.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855284036\",\"name\":\"Get the number of rows affected\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Use a cursor.rowcount method to get the number of rows affected. The count depends on how many rows you are deleting. <br\/>You can also <a href=\\\"https:\/\/pynative.com\/python-mysql-select-query-to-fetch-data\/\\\">Execute a MySQL select query from Python<\/a> to Verify the result.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855485727\",\"name\":\"Close the cursor object and database connection object\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"use cursor.clsoe() and connection.clsoe() method to close open connections after your work completes.\"}]}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Python MySQL Delete table Data [Complete Guide]","description":"Python MySQL delete query to delete single row, multiple rows, all rows, single column and multiple columns of a Delete table and database. use python varible in delete query.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pynative.com\/python-mysql-delete-data\/","og_locale":"en_US","og_type":"article","og_title":"Python Delete data from MySQL Table","og_description":"Python MySQL delete query to delete single row, multiple rows, all rows, single column and multiple columns of a Delete table and database. use python varible in delete query.","og_url":"https:\/\/pynative.com\/python-mysql-delete-data\/","og_site_name":"PYnative","article_published_time":"2018-07-01T15:45:14+00:00","article_modified_time":"2021-03-09T05:32:57+00:00","og_image":[{"width":295,"height":235,"url":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png","type":"image\/png"}],"author":"Vishal","twitter_card":"summary_large_image","twitter_creator":"@PyNative","twitter_site":"@PyNative","twitter_misc":{"Written by":"Vishal","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#article","isPartOf":{"@id":"https:\/\/pynative.com\/python-mysql-delete-data\/"},"author":{"name":"Vishal","@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"headline":"Python Delete data from MySQL Table","datePublished":"2018-07-01T15:45:14+00:00","dateModified":"2021-03-09T05:32:57+00:00","mainEntityOfPage":{"@id":"https:\/\/pynative.com\/python-mysql-delete-data\/"},"wordCount":892,"commentCount":1,"publisher":{"@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"image":{"@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage"},"thumbnailUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png","keywords":["Python MySQL"],"articleSection":["Python","Python Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pynative.com\/python-mysql-delete-data\/#respond"]}],"accessibilityFeature":["tableOfContents"]},{"@type":"WebPage","@id":"https:\/\/pynative.com\/python-mysql-delete-data\/","url":"https:\/\/pynative.com\/python-mysql-delete-data\/","name":"Python MySQL Delete table Data [Complete Guide]","isPartOf":{"@id":"https:\/\/pynative.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage"},"image":{"@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage"},"thumbnailUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png","datePublished":"2018-07-01T15:45:14+00:00","dateModified":"2021-03-09T05:32:57+00:00","description":"Python MySQL delete query to delete single row, multiple rows, all rows, single column and multiple columns of a Delete table and database. use python varible in delete query.","breadcrumb":{"@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pynative.com\/python-mysql-delete-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#primaryimage","url":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png","contentUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png","width":295,"height":235,"caption":"Python MySQL Delete Data"},{"@type":"BreadcrumbList","@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pynative.com\/"},{"@type":"ListItem","position":2,"name":"Python","item":"https:\/\/pynative.com\/python\/"},{"@type":"ListItem","position":3,"name":"Databases","item":"https:\/\/pynative.com\/python\/databases\/"},{"@type":"ListItem","position":4,"name":"Python Delete data from MySQL Table"}]},{"@type":"WebSite","@id":"https:\/\/pynative.com\/#website","url":"https:\/\/pynative.com\/","name":"PYnative","description":"Python Programming","publisher":{"@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pynative.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f","name":"Vishal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pynative.com\/#\/schema\/person\/image\/","url":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg","contentUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/01\/vishalHule.jpg","width":968,"height":1065,"caption":"Vishal"},"logo":{"@id":"https:\/\/pynative.com\/#\/schema\/person\/image\/"},"description":"Founder of PYnative.com. I am a Python developer and I love to write articles to help developers. | All the best for your future Python endeavors!","sameAs":["https:\/\/pynative.com"]},{"@type":"HowTo","@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#howto-1","name":"Python Delete data from MySQL Table","mainEntityOfPage":{"@id":"https:\/\/pynative.com\/python-mysql-delete-data\/#article"},"description":"How to delete a row in MySQL using Python","step":[{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613854588396","name":"Connect to MySQL from Python","itemListElement":[{"@type":"HowToDirection","text":"Refer to <a href=\"https:\/\/pynative.com\/python-mysql-database-connection\/\">Python MySQL database connection<\/a> to connect to MySQL database from Python using MySQL Connector module"}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613854736175","name":"Define a SQL Delete Query","itemListElement":[{"@type":"HowToDirection","text":"Next, prepare a SQL delete query to delete a row from a table. Delete query contains the row to be deleted based on a condition placed in where clause of a query.<br\/>For example, DELETE FROM MySQL_table WHERE id=10;"}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613884793763","name":"Get Cursor Object from Connection","itemListElement":[{"@type":"HowToDirection","text":"Next, use a connection.cursor() method to create a cursor object. This method creates a new MySQLCursor object."}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855028385","name":"Execute the delete query using execute() method","itemListElement":[{"@type":"HowToDirection","text":"Execute the delete query using the cursor.execute() method. This method executes the operation stored in the delete query. <br\/>After a successful delete operation, the execute() method returns us the number of rows affected."}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855113883","name":"Commit your changes","itemListElement":[{"@type":"HowToDirection","text":"After successfully executing a delete operation, make changes persistent into a database using the commit() of a connection class."}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855284036","name":"Get the number of rows affected","itemListElement":[{"@type":"HowToDirection","text":"Use a cursor.rowcount method to get the number of rows affected. The count depends on how many rows you are deleting. <br\/>You can also <a href=\"https:\/\/pynative.com\/python-mysql-select-query-to-fetch-data\/\">Execute a MySQL select query from Python<\/a> to Verify the result."}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-delete-data\/#how-to-step-1613855485727","name":"Close the cursor object and database connection object","itemListElement":[{"@type":"HowToDirection","text":"use cursor.clsoe() and connection.clsoe() method to close open connections after your work completes."}]}],"inLanguage":"en-US"}]}},"featured_image_src":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png","featured_image_src_square":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_delete_data.png","author_info":{"display_name":"Vishal","author_link":"https:\/\/pynative.com\/author\/vishal\/"},"_links":{"self":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/posts\/182"}],"collection":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/comments?post=182"}],"version-history":[{"count":0,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/posts\/182\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/media\/2085"}],"wp:attachment":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/media?parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/categories?post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/tags?post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}