{"id":26648,"date":"2024-03-16T07:02:42","date_gmt":"2024-03-16T07:02:42","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/"},"modified":"2024-03-22T09:05:41","modified_gmt":"2024-03-22T09:05:41","slug":"how-to-update-multiple-records-at-once-in-mysql-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/","title":{"rendered":"How to update multiple records at once in MySQL?"},"content":{"rendered":"<p>In MySQL, you can use the UPDATE statement to update multiple records at once. The WHERE clause can be used to specify the conditions of the records that need to be updated.<\/p>\n<p>Here is an example demonstrating how to update multiple records at once:<\/p>\n<pre class=\"post-pre\"><code>UPDATE \u8868\u540d\r\nSET \u5217\u540d1 = \u65b0\u503c1, \u5217\u540d2 = \u65b0\u503c2\r\nWHERE \u6761\u4ef6;\r\n<\/code><\/pre>\n<p>The table name refers to the name of the table to be updated, column1 and column2 refer to the names of the columns to be updated, newValue1 and newValue2 are the new values to be updated to, and the condition specifies the records to be updated.<\/p>\n<p>For example, suppose there is a table called students, which includes columns for id, name, and age. Now, to change the names of all students under the age of 18 to &#8220;Minor&#8221;, you can use the following statement:<\/p>\n<pre class=\"post-pre\"><code>UPDATE students\r\nSET name = '\u672a\u6210\u5e74'\r\nWHERE age &lt; 18;\r\n<\/code><\/pre>\n<p>This way, the names of all students under the age of 18 will be updated to &#8220;minor&#8221;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MySQL, you can use the UPDATE statement to update multiple records at once. The WHERE clause can be used to specify the conditions of the records that need to be updated. Here is an example demonstrating how to update multiple records at once: UPDATE \u8868\u540d SET \u5217\u540d1 = \u65b0\u503c1, \u5217\u540d2 = \u65b0\u503c2 WHERE \u6761\u4ef6; [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-26648","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to update multiple records at once in MySQL? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to update multiple records at once in MySQL?\" \/>\n<meta property=\"og:description\" content=\"In MySQL, you can use the UPDATE statement to update multiple records at once. The WHERE clause can be used to specify the conditions of the records that need to be updated. Here is an example demonstrating how to update multiple records at once: UPDATE \u8868\u540d SET \u5217\u540d1 = \u65b0\u503c1, \u5217\u540d2 = \u65b0\u503c2 WHERE \u6761\u4ef6; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T07:02:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T09:05:41+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"How to update multiple records at once in MySQL?\",\"datePublished\":\"2024-03-16T07:02:42+00:00\",\"dateModified\":\"2024-03-22T09:05:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/\"},\"wordCount\":152,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/\",\"name\":\"How to update multiple records at once in MySQL? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T07:02:42+00:00\",\"dateModified\":\"2024-03-22T09:05:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to update multiple records at once in MySQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to update multiple records at once in MySQL? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/","og_locale":"en_US","og_type":"article","og_title":"How to update multiple records at once in MySQL?","og_description":"In MySQL, you can use the UPDATE statement to update multiple records at once. The WHERE clause can be used to specify the conditions of the records that need to be updated. Here is an example demonstrating how to update multiple records at once: UPDATE \u8868\u540d SET \u5217\u540d1 = \u65b0\u503c1, \u5217\u540d2 = \u65b0\u503c2 WHERE \u6761\u4ef6; [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T07:02:42+00:00","article_modified_time":"2024-03-22T09:05:41+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"How to update multiple records at once in MySQL?","datePublished":"2024-03-16T07:02:42+00:00","dateModified":"2024-03-22T09:05:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/"},"wordCount":152,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/","name":"How to update multiple records at once in MySQL? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T07:02:42+00:00","dateModified":"2024-03-22T09:05:41+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-records-at-once-in-mysql-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to update multiple records at once in MySQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=26648"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26648\/revisions"}],"predecessor-version":[{"id":60823,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26648\/revisions\/60823"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=26648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=26648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=26648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}