{"id":180,"date":"2018-07-01T21:12:44","date_gmt":"2018-07-01T15:42:44","guid":{"rendered":"https:\/\/pynative.com\/?p=180"},"modified":"2021-03-09T11:03:40","modified_gmt":"2021-03-09T05:33:40","slug":"python-mysql-update-data","status":"publish","type":"post","link":"https:\/\/pynative.com\/python-mysql-update-data\/","title":{"rendered":"Python Update MySQL Table"},"content":{"rendered":"\n<p>This article demonstrates how to execute a <strong>MySQL UPDATE query from Python<\/strong> to modify the MySQL table&#8217;s data.<\/p>\n\n\n\n<p>Goals of this lesson. You\u2019ll learn the following MySQL UPDATE operations from Python using a &#8216;MySQL Connector&#8217; module.<\/p>\n\n\n\n<ul><li>Update single and multiple rows, single and multiple columns<\/li><li>Use a Python variable in a parameterized query to update table rows.<\/li><li>Also, Update a column with date-time and timestamp values<\/li><li>The role of commit and rollback in the update operation.<\/li><\/ul>\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-prerequisite\" data-level=\"2\">Prerequisite<\/a><\/li><li><a href=\"#h-example-to-update-a-row-of-mysql-table\" data-level=\"2\">Example to Update a row of MySQL Table<\/a><\/li><li><a href=\"#h-use-a-python-variable-in-mysql-update-query\" data-level=\"2\">Use a Python variable in MySQL Update&nbsp;query<\/a><\/li><li><a href=\"#h-update-multiple-rows-of-mysql-table-using-python\" data-level=\"2\">Update Multiple Rows of MySQL Table using Python<\/a><ul><li><a href=\"#h-python-update-multiple-columns-of-mysql-table\" data-level=\"3\">Python update multiple Columns of MySQL table<\/a><\/li><\/ul><\/li><li><a href=\"#h-update-datetime-and-timestamp-column-of-a-mysql-table-from-python\" data-level=\"2\">Update Datetime and timestamp column of a MySQL table 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-prerequisite\">Prerequisite<\/h2>\n\n\n\n<p>Before executing the following program, make sure you have the following in place \u2212<\/p>\n\n\n\n<ul><li><strong>Username<\/strong> and <strong>password<\/strong> that you need to connect MySQL<\/li><li><strong>MySQL database table name<\/strong> which you want to update.<\/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>For this article, I am using a <strong>Laptop<\/strong> 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 create a MySQL table from Python.<\/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 UPDATE 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-example-to-update-a-row-of-mysql-table\">Example to Update a row of MySQL Table<\/h2>\n\n\n\n<p>To perform a SQL UPDATE query from Python, you need to follow the following steps: &#8211;<\/p>\n\n\n\n<div class=\"schema-how-to wp-block-yoast-how-to-block\"><p class=\"schema-how-to-description\">How to Update MySQL Table in 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\">Prepare a SQL Update Query<\/strong> <p class=\"schema-how-to-step-text\">Prepare an update statement query with data to update. FOr example, <code>UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;<\/code><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613855028385\"><strong class=\"schema-how-to-step-name\">Execute the UPDATE query, using cursor.execute()<\/strong> <p class=\"schema-how-to-step-text\">Execute the UPDATE query using <code>cursor.execute()<\/code> method. This method execute the operation stored in the UPDATE query.<\/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\">Make modification 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\">Extract the number of rows affected<\/strong> <p class=\"schema-how-to-step-text\">After a successful update operation, use a <code>cursor.rowcount<\/code> method to get the number of rows affected. The count depends on how many rows you are updating.<\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1613855399906\"><strong class=\"schema-how-to-step-name\">Verify result using the SQL SELECT query<\/strong> <p class=\"schema-how-to-step-text\">Execute a <a href=\"https:\/\/pynative.com\/python-mysql-select-query-to-fetch-data\/\">MySQL select query from Python<\/a> to see the new changes<\/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=\"448\" src=\"https:\/\/pynative.com\/wp-content\/uploads\/2018\/12\/python_update_mysql_table.png\" alt=\"Python update MySQL table's data\" class=\"wp-image-1213\" srcset=\"https:\/\/pynative.com\/wp-content\/uploads\/2018\/12\/python_update_mysql_table.png 666w, https:\/\/pynative.com\/wp-content\/uploads\/2018\/12\/python_update_mysql_table-300x202.png 300w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><figcaption>Python update MySQL table&#8217;s data<\/figcaption><\/figure><\/div>\n\n\n\n<p>Let&#8217;s see the program now. In this program, we are updating a Laptop table by changing the price column of the first row.<\/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\">'pynative'<\/span>,\n                                         password=<span class=\"hljs-string\">'pynative@#29'<\/span>)\n    cursor = connection.cursor()\n\n    print(<span class=\"hljs-string\">\"Before updating a record \"<\/span>)\n    sql_select_query = <span class=\"hljs-string\">\"\"\"select * from Laptop where id = 1\"\"\"<\/span>\n    cursor.execute(sql_select_query)\n    record = cursor.fetchone()\n    print(record)\n\n    <span class=\"hljs-comment\"># Update single record now<\/span>\n    sql_update_query = <span class=\"hljs-string\">\"\"\"Update Laptop set Price = 7000 where id = 1\"\"\"<\/span>\n    cursor.execute(sql_update_query)\n    connection.commit()\n    print(<span class=\"hljs-string\">\"Record Updated successfully \"<\/span>)\n\n    print(<span class=\"hljs-string\">\"After updating record \"<\/span>)\n    cursor.execute(sql_select_query)\n    record = cursor.fetchone()\n    print(record)\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 update table record: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        connection.close()\n        print(<span class=\"hljs-string\">\"MySQL connection is closed\"<\/span>)\n<\/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\">Before updating a row\n(1, 'Lenovo ThinkPad P71', 6459.0, datetime.date(2019, 8, 14))\nRecord Updated successfully \n\nAfter updating row\n(1, 'Lenovo ThinkPad P71', 7000.0, datetime.date(2019, 8, 14))\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=\"295\" src=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_updating_record.png\" alt=\"MySQL Laptop table after updating record\" class=\"wp-image-4569\" srcset=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_updating_record.png 454w, https:\/\/pynative.com\/wp-content\/uploads\/2019\/08\/mysql_laptop_table_after_updating_record-300x195.png 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/><figcaption>MySQL Laptop table after updating record<\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-columns has-background is-layout-flex wp-container-core-columns-is-layout-3 wp-block-columns-is-layout-flex\" style=\"background-color:#fff3cd\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Note<\/strong>:<\/p>\n\n\n\n<ul><li>Don&#8217;t forget to close the cursor and database connection objects and Catch any SQL exceptions that may occur during this process<\/li><li>We also used <a href=\"https:\/\/pynative.com\/python-mysql-transaction-management-using-commit-rollback\/\">commit() and rollback()<\/a> method. commit() to make changes persistent in the database and rollback() revert the changes if any database error occurred.<\/li><\/ul>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-use-a-python-variable-in-mysql-update-query\">Use a Python variable in MySQL Update&nbsp;query<\/h2>\n\n\n\n<p>Sometimes we need input from the user, such as when users update their password or any other details through User Interface. Or when you want to update details dynamically by passing Python variables into a query. Such as setting column value using the variable.<\/p>\n\n\n\n<p>It is always best practice to use <a href=\"https:\/\/pynative.com\/python-mysql-execute-parameterized-query-using-prepared-statement\/\">parameterized query and prepared statement<\/a>, i.e., placeholders ( <code>%s<\/code> ) inside any SQL statements that contain input from users. This helps us prevent SQL injection and other SQL issues.<br>Read more on What is a Parameterized Query and its performance benefits.<\/p>\n\n\n\n<p>Let&#8217; s see the example program now.<\/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-function\"><span class=\"hljs-keyword\">def<\/span> <span class=\"hljs-title\">update_laptop_price<\/span><span class=\"hljs-params\">(id, price)<\/span>:<\/span>\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\">'roo'<\/span>,\n                                             password=<span class=\"hljs-string\">'pynative@#29'<\/span>)\n\n        cursor = connection.cursor()\n        sql_update_query = <span class=\"hljs-string\">\"\"\"Update laptop set price = %s where id = %s\"\"\"<\/span>\n        input_data = (price, id)\n        cursor.execute(sql_update_query, input_data)\n        connection.commit()\n        print(<span class=\"hljs-string\">\"Record Updated 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 update record to 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\nupdate_laptop_price(<span class=\"hljs-number\">7500<\/span>, <span class=\"hljs-number\">1<\/span>)\nupdate_laptop_price(<span class=\"hljs-number\">5000<\/span>, <span class=\"hljs-number\">2<\/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: &#8211;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Record Updated successfully \nMySQL connection is closed\nRecord Updated successfully \nMySQL connection is closed<\/pre>\n\n\n\n<p>Let&#8217;s understand the above program: &#8211;<\/p>\n\n\n\n<ul><li>We used the prepared statement to accept user input using a placeholder, i.e., we put two placeholders in the update query, one for the &#8220;Price&#8221; column and the other is for the&#8221; id&#8221; column.<\/li><li>Next, we added those two columns value in the tuple format in sequential order and passed SQL update query and input tuple to the <code>cursor.execute()<\/code> method. Remember tuple contains user data in the sequential order of placeholders.<\/li><li>In the end, we are committing our changes to the database using the <code>connection.commit()<\/code>.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-update-multiple-rows-of-mysql-table-using-python\">Update Multiple Rows of MySQL Table using Python<\/h2>\n\n\n\n<p>It is possible to update multiple rows in a single SQL Query. You can also call it a bulk update. Use the <code>cursor.executemany()<\/code> method of cursor object to update multiple rows of a table.<\/p>\n\n\n\n<p><strong>The syntax&nbsp;of&nbsp;the executemany() method<\/strong><\/p>\n\n\n<pre id=\"syntax\" 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\">cursor.executemany(operation, seq_of_params)<\/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>\n\n\n<p>This method executes <code>operation<\/code> against all parameter sequences in the sequence <code>seq_of_params<\/code> argument.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code3\"  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\n    cursor = connection.cursor()\n    sql_update_query = <span class=\"hljs-string\">\"\"\"Update Laptop set Price = %s where id = %s\"\"\"<\/span>\n\n    <span class=\"hljs-comment\"># multiple records to be updated in tuple format<\/span>\n    records_to_update = &#91;(<span class=\"hljs-number\">3000<\/span>, <span class=\"hljs-number\">3<\/span>), (<span class=\"hljs-number\">2750<\/span>, <span class=\"hljs-number\">4<\/span>)]\n    cursor.executemany(sql_update_query, records_to_update)\n    connection.commit()\n\n    print(cursor.rowcount, <span class=\"hljs-string\">\"Records of a laptop table updated 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 update records to database: {}\"<\/span>.format(error))\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\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('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 Records of a laptop table updated successfully\nconnection is closed\n<\/pre>\n\n\n\n<p><strong>Let&#8217;s&nbsp; understand the above program<\/strong><\/p>\n\n\n\n<ul><li>We defined a SQL update query with two placeholders (&#8220;Price&#8221; and &#8220;Id&#8221; column ). and prepared a list of records to be updated. This List contains a tuple for each row. Here we created two tuples, so we are updated two rows.<\/li><li>We used the <code>cursor.executemany()<\/code> method to update multiple rows of a database table.<\/li><li>Using the <code>cursor.rowcount<\/code> we can find how many rows are updated successfully.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-python-update-multiple-columns-of-mysql-table\">Python update multiple Columns of MySQL table<\/h3>\n\n\n\n<p>We can also update multiple columns of the MySQL table in a single query. Use parameterized query using a placeholder to update multiple columns. Let see this with an example program.<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code4\"  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\n    cursor = connection.cursor()\n    sql_update_query = <span class=\"hljs-string\">\"\"\"Update Laptop set Name = %s, Price = %s where id = %s\"\"\"<\/span>\n\n    name = <span class=\"hljs-string\">\"HP Pavilion\"<\/span>\n    price = <span class=\"hljs-number\">2200<\/span>\n    id = <span class=\"hljs-number\">4<\/span>\n    input = (name, price, id)\n\n    cursor.execute(sql_update_query, input)\n    connection.commit()\n    print(<span class=\"hljs-string\">\"Multiple columns updated 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 update columns of table: {}\"<\/span>.format(error))\n\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\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('code4', 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\">Multiple column updated successfully\nMySQL connection is closed<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-update-datetime-and-timestamp-column-of-a-mysql-table-from-python\">Update Datetime and timestamp column of a MySQL table from Python<\/h2>\n\n\n\n<p>Suppose you have a date column in a MySQL table and you want to update a <code>datetime.datetime()<\/code> object into this column. Let\u2019s see how to prepare an update query to update the <code>datetime<\/code> column of a table<\/p>\n\n\n<div class=\"hljstoolbar\"><pre id=\"code5\"  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\">from<\/span> datetime <span class=\"hljs-keyword\">import<\/span> datetime\n\n<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_update_query = <span class=\"hljs-string\">\"\"\"Update Laptop set Purchase_date = %s where id = %s\"\"\"<\/span>\n\n    current_Date = datetime.now()\n    formatted_date = current_Date.strftime(<span class=\"hljs-string\">'%Y-%m-%d %H:%M:%S'<\/span>)\n    id = <span class=\"hljs-number\">2<\/span>\n    input = (formatted_date, id)\n    cursor.execute(sql_update_query, input)\n    connection.commit()\n    print(<span class=\"hljs-string\">\"Purchased Date Updated 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 update purchased date {}\"<\/span>.format(error))\n\n<span class=\"hljs-keyword\">finally<\/span>:\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\n        connection.close()\n        print(<span class=\"hljs-string\">\"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('code5', this);\"><i class=\"far fa-copy1\" aria-hidden=\"true\"><\/i><\/button><\/div>\n\n\n<p>You should get the following output after the execution of the above code.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Purchased Date Updated successfully \nconnection is closed\n<\/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 lesson, Please solve a <a href=\"https:\/\/pynative.com\/python-database-programming-exercise-with-solution\/\">Python Database Exercise project<\/a> to practice and master the Python Database operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article demonstrates how to execute a MySQL UPDATE query from Python to modify the MySQL table&#8217;s data. Goals of this lesson. You\u2019ll learn the following MySQL UPDATE operations from Python using a &#8216;MySQL Connector&#8217; module. Update single and multiple rows, single and multiple columns Use a Python variable in a parameterized query to update [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2090,"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.6 (Yoast SEO v22.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python MySQL Update Table [Guide]<\/title>\n<meta name=\"description\" content=\"Python MySQL update single row, multiple rows, single column and multiple columns. Update column with datetime values. Use python variable in a parameterized query to update table data.\" \/>\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-update-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python Update MySQL Table\" \/>\n<meta property=\"og:description\" content=\"Python MySQL update single row, multiple rows, single column and multiple columns. Update column with datetime values. Use python variable in a parameterized query to update table data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pynative.com\/python-mysql-update-data\/\" \/>\n<meta property=\"og:site_name\" content=\"PYnative\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-01T15:42:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-09T05:33:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png\" \/>\n\t<meta property=\"og:image:width\" content=\"298\" \/>\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-update-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/\"},\"author\":{\"name\":\"Vishal\",\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"headline\":\"Python Update MySQL Table\",\"datePublished\":\"2018-07-01T15:42:44+00:00\",\"dateModified\":\"2021-03-09T05:33:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/\"},\"wordCount\":963,\"commentCount\":14,\"publisher\":{\"@id\":\"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f\"},\"image\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png\",\"keywords\":[\"Python MySQL\"],\"articleSection\":[\"Python\",\"Python Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/pynative.com\/python-mysql-update-data\/#respond\"]}],\"accessibilityFeature\":[\"tableOfContents\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/\",\"url\":\"https:\/\/pynative.com\/python-mysql-update-data\/\",\"name\":\"Python MySQL Update Table [Guide]\",\"isPartOf\":{\"@id\":\"https:\/\/pynative.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png\",\"datePublished\":\"2018-07-01T15:42:44+00:00\",\"dateModified\":\"2021-03-09T05:33:40+00:00\",\"description\":\"Python MySQL update single row, multiple rows, single column and multiple columns. Update column with datetime values. Use python variable in a parameterized query to update table data.\",\"breadcrumb\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pynative.com\/python-mysql-update-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage\",\"url\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png\",\"contentUrl\":\"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png\",\"width\":298,\"height\":235,\"caption\":\"Python MySQL Update table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pynative.com\/python-mysql-update-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 Update 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-update-data\/#howto-1\",\"name\":\"Python Update MySQL Table\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pynative.com\/python-mysql-update-data\/#article\"},\"description\":\"How to Update MySQL Table in Python\",\"step\":[{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-update-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-update-data\/#how-to-step-1613854736175\",\"name\":\"Prepare a SQL Update Query\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Prepare an update statement query with data to update. FOr example, UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855028385\",\"name\":\"Execute the UPDATE query, using cursor.execute()\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Execute the UPDATE query using cursor.execute() method. This method execute the operation stored in the UPDATE query.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855113883\",\"name\":\"Commit your changes\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Make modification persistent into a database using the commit() of a connection class.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855284036\",\"name\":\"Extract the number of rows affected\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"After a successful update operation, use a cursor.rowcount method to get the number of rows affected. The count depends on how many rows you are updating.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855399906\",\"name\":\"Verify result using the SQL SELECT query\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Execute a <a href=\\\"https:\/\/pynative.com\/python-mysql-select-query-to-fetch-data\/\\\">MySQL select query from Python<\/a> to see the new changes\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/pynative.com\/python-mysql-update-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 Update Table [Guide]","description":"Python MySQL update single row, multiple rows, single column and multiple columns. Update column with datetime values. Use python variable in a parameterized query to update table data.","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-update-data\/","og_locale":"en_US","og_type":"article","og_title":"Python Update MySQL Table","og_description":"Python MySQL update single row, multiple rows, single column and multiple columns. Update column with datetime values. Use python variable in a parameterized query to update table data.","og_url":"https:\/\/pynative.com\/python-mysql-update-data\/","og_site_name":"PYnative","article_published_time":"2018-07-01T15:42:44+00:00","article_modified_time":"2021-03-09T05:33:40+00:00","og_image":[{"width":298,"height":235,"url":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_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-update-data\/#article","isPartOf":{"@id":"https:\/\/pynative.com\/python-mysql-update-data\/"},"author":{"name":"Vishal","@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"headline":"Python Update MySQL Table","datePublished":"2018-07-01T15:42:44+00:00","dateModified":"2021-03-09T05:33:40+00:00","mainEntityOfPage":{"@id":"https:\/\/pynative.com\/python-mysql-update-data\/"},"wordCount":963,"commentCount":14,"publisher":{"@id":"https:\/\/pynative.com\/#\/schema\/person\/64b55d5bde2265918c5a9931de4de71f"},"image":{"@id":"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage"},"thumbnailUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png","keywords":["Python MySQL"],"articleSection":["Python","Python Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pynative.com\/python-mysql-update-data\/#respond"]}],"accessibilityFeature":["tableOfContents"]},{"@type":"WebPage","@id":"https:\/\/pynative.com\/python-mysql-update-data\/","url":"https:\/\/pynative.com\/python-mysql-update-data\/","name":"Python MySQL Update Table [Guide]","isPartOf":{"@id":"https:\/\/pynative.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage"},"image":{"@id":"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage"},"thumbnailUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png","datePublished":"2018-07-01T15:42:44+00:00","dateModified":"2021-03-09T05:33:40+00:00","description":"Python MySQL update single row, multiple rows, single column and multiple columns. Update column with datetime values. Use python variable in a parameterized query to update table data.","breadcrumb":{"@id":"https:\/\/pynative.com\/python-mysql-update-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pynative.com\/python-mysql-update-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pynative.com\/python-mysql-update-data\/#primaryimage","url":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png","contentUrl":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_data.png","width":298,"height":235,"caption":"Python MySQL Update table"},{"@type":"BreadcrumbList","@id":"https:\/\/pynative.com\/python-mysql-update-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 Update 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-update-data\/#howto-1","name":"Python Update MySQL Table","mainEntityOfPage":{"@id":"https:\/\/pynative.com\/python-mysql-update-data\/#article"},"description":"How to Update MySQL Table in Python","step":[{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-update-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-update-data\/#how-to-step-1613854736175","name":"Prepare a SQL Update Query","itemListElement":[{"@type":"HowToDirection","text":"Prepare an update statement query with data to update. FOr example, UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;"}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855028385","name":"Execute the UPDATE query, using cursor.execute()","itemListElement":[{"@type":"HowToDirection","text":"Execute the UPDATE query using cursor.execute() method. This method execute the operation stored in the UPDATE query."}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855113883","name":"Commit your changes","itemListElement":[{"@type":"HowToDirection","text":"Make modification persistent into a database using the commit() of a connection class."}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855284036","name":"Extract the number of rows affected","itemListElement":[{"@type":"HowToDirection","text":"After a successful update operation, use a cursor.rowcount method to get the number of rows affected. The count depends on how many rows you are updating."}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-update-data\/#how-to-step-1613855399906","name":"Verify result using the SQL SELECT query","itemListElement":[{"@type":"HowToDirection","text":"Execute a <a href=\"https:\/\/pynative.com\/python-mysql-select-query-to-fetch-data\/\">MySQL select query from Python<\/a> to see the new changes"}]},{"@type":"HowToStep","url":"https:\/\/pynative.com\/python-mysql-update-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_update_data.png","featured_image_src_square":"https:\/\/pynative.com\/wp-content\/uploads\/2019\/02\/python_mysql_update_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\/180"}],"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=180"}],"version-history":[{"count":0,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/posts\/180\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/media\/2090"}],"wp:attachment":[{"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/media?parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/categories?post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pynative.com\/wp-json\/wp\/v2\/tags?post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}