{"id":13766,"date":"2023-12-29T01:06:22","date_gmt":"2023-12-29T08:06:22","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=13766"},"modified":"2023-12-29T01:06:23","modified_gmt":"2023-12-29T08:06:23","slug":"mysql-replace","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/","title":{"rendered":"MySQL REPLACE"},"content":{"rendered":"\n<p><strong>Summary<\/strong><em>:<\/em> in this tutorial, you will learn how to use the MySQL <code>REPLACE<\/code> statement to insert or update data in database tables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to MySQL REPLACE statement<\/h2>\n\n\n\n<p>The MySQL <code>REPLACE<\/code> statement is an extension to the <a href=\"http:\/\/www.sqltutorial.org\">SQL <\/a><a href=\"http:\/\/www.sqltutorial.org\">Standard<\/a>. The MySQL <code>REPLACE<\/code> statement works as follows:<\/p>\n\n\n\n<p>Step 1. <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-insert\/\">Insert a new row into the table<\/a>, if a duplicate key error occurs.<\/p>\n\n\n\n<p>Step 2. If the insertion fails due to a duplicate-key error occurs:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-delete\/\">Delete<\/a>&nbsp;the conflicting row that causes the duplicate key error from the table.<\/li>\n\n\n\n<li>Insert the new row into the table again.<\/li>\n<\/ul>\n\n\n\n<p>To determine whether the new row that already exists in the table, MySQL uses <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-primary-key\/\">PRIMARY KEY<\/a><\/code> or <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-unique\/\">UNIQUE KEY<\/a><\/code>&nbsp;index. If the table does not have one of these indexes, the <code>REPLACE<\/code> statement works like an&nbsp;<code>INSERT<\/code> statement.<\/p>\n\n\n\n<p>To use the <code>REPLACE<\/code> statement, you need to have at least both <code>INSERT<\/code> and <code>DELETE<\/code> privileges for the table.<\/p>\n\n\n\n<p class=\"warning\">Notice that MySQL has the&nbsp;<code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-string-functions\/mysql-replace-function\/\">REPLACE<\/a><\/code> string function&nbsp;which is not the <code>REPLACE<\/code> statement covered in this tutorial.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using MySQL REPLACE to insert a new row<\/h2>\n\n\n\n<p>The following illustrates the syntax of the <code>REPLACE<\/code> statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">REPLACE<\/span> &#91;<span class=\"hljs-keyword\">INTO<\/span>] table_name(column_list)\n<span class=\"hljs-keyword\">VALUES<\/span>(value_list);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>It is similar to the&nbsp;<code>INSERT<\/code>&nbsp;statement except for the keyword&nbsp;<code>REPLACE<\/code>. Let&#8217;s take a look at the following example of using the <code>REPLACE<\/code> statement to see how it works.<\/p>\n\n\n\n<p>First, <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-create-table\/\">create a new table<\/a> named <code>cities<\/code> as follows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> cities (\n    <span class=\"hljs-keyword\">id<\/span> <span class=\"hljs-built_in\">INT<\/span> AUTO_INCREMENT PRIMARY <span class=\"hljs-keyword\">KEY<\/span>,\n    <span class=\"hljs-keyword\">name<\/span> <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">50<\/span>),\n    population <span class=\"hljs-built_in\">INT<\/span> <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Next, <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-insert-multiple-rows\/\">insert some rows<\/a> into the <code>cities<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> cities(<span class=\"hljs-keyword\">name<\/span>,population)\n<span class=\"hljs-keyword\">VALUES<\/span>(<span class=\"hljs-string\">'New York'<\/span>,<span class=\"hljs-number\">8008278<\/span>),\n\t  (<span class=\"hljs-string\">'Los Angeles'<\/span>,<span class=\"hljs-number\">3694825<\/span>),\n\t  (<span class=\"hljs-string\">'San Diego'<\/span>,<span class=\"hljs-number\">1223405<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Then, <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-select-from\/\">query data<\/a> from the <code>cities<\/code> table to verify the insert operation.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> cities;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"205\" height=\"81\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table.png\" alt=\"MySQL REPLACE - sample table\" class=\"wp-image-8385\" srcset=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table.png 205w, https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table-200x79.png 200w\" sizes=\"auto, (max-width: 205px) 100vw, 205px\" \/><\/figure>\n\n\n\n<p>After that, use the <code>REPLACE<\/code> statement to update the population of the <code>Los Angeles<\/code> city to <code>3696820<\/code>.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">REPLACE<\/span> <span class=\"hljs-keyword\">INTO<\/span> cities(<span class=\"hljs-keyword\">id<\/span>,population)\n<span class=\"hljs-keyword\">VALUES<\/span>(<span class=\"hljs-number\">2<\/span>,<span class=\"hljs-number\">3696820<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Finally, query&nbsp;the data of the <code>cities<\/code> table again to verify the replacement.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> cities;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"191\" height=\"79\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-example.png\" alt=\"MySQL REPLACE example\" class=\"wp-image-8386\"\/><\/figure>\n\n\n\n<p>The value of the <code>name<\/code> column is <code>NULL<\/code> now. <\/p>\n\n\n\n<p>The <code>REPLACE<\/code> statement works as follows:<\/p>\n\n\n\n<ol style=\"list-style-type:1\" class=\"orderedlist wp-block-list\">\n<li>First, the <code>REPLACE<\/code> statement attempted to insert a new row into <code>cities<\/code> the table. The insertion failed because the id 2 already exists in the <code>cities<\/code> table.<\/li>\n\n\n\n<li>Then, the <code>REPLACE<\/code> statement deleted the row with id 2 and inserted a new row with the same id 2 and population <code>3696820<\/code>. Because no value is specified for the name column, it was set to <code>NULL<\/code>.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Using MySQL REPLACE statement to update a row<\/h2>\n\n\n\n<p>The following illustrates how to use the <code>REPLACE<\/code> statement to update data:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">REPLACE<\/span> <span class=\"hljs-keyword\">INTO<\/span> <span class=\"hljs-keyword\">table<\/span>\n<span class=\"hljs-keyword\">SET<\/span> column1 = value1,\n    column2 = value2;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>This statement is like the <code>UPDATE<\/code> statement except for the <code>REPLACE<\/code> keyword. In addition, it has no <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-where\/\">WHERE<\/a><\/code> clause.<\/p>\n\n\n\n<p>This example uses the <code>REPLACE<\/code> statement to update the population of the city <code>Phoenix<\/code> to <code>1768980<\/code>:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">REPLACE<\/span> <span class=\"hljs-keyword\">INTO<\/span> cities\n<span class=\"hljs-keyword\">SET<\/span> <span class=\"hljs-keyword\">id<\/span> = <span class=\"hljs-number\">4<\/span>,\n    <span class=\"hljs-keyword\">name<\/span> = <span class=\"hljs-string\">'Phoenix'<\/span>,\n    population = <span class=\"hljs-number\">1768980<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Unlike the <code>UPDATE<\/code> statement, if you don&#8217;t specify the value for the column in the <code>SET<\/code> clause, the <code>REPLACE<\/code> statement will use the default value of that column.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> cities;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Using MySQL REPLACE to insert data from a SELECT statement<\/h2>\n\n\n\n<p>The following illustrates the <code>REPLACE<\/code> statement that inserts data into a table with the data coming from a query.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">REPLACE<\/span> <span class=\"hljs-keyword\">INTO<\/span> table_1(column_list)\n<span class=\"hljs-keyword\">SELECT<\/span> column_list\n<span class=\"hljs-keyword\">FROM<\/span> table_2\n<span class=\"hljs-keyword\">WHERE<\/span> where_condition;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p class=\"note\">Note that this form of the <code>REPLACE<\/code> statement is similar to <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-insert-into-select\/\">INSERT INTO SELECT<\/a><\/code> statement.<\/p>\n\n\n\n<p>The following statement uses the <code>REPLACE INTO<\/code> statement to copy a row within the same table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">REPLACE<\/span> <span class=\"hljs-keyword\">INTO<\/span> \n    cities(<span class=\"hljs-keyword\">name<\/span>,population)\n<span class=\"hljs-keyword\">SELECT<\/span> \n    <span class=\"hljs-keyword\">name<\/span>,\n    population \n<span class=\"hljs-keyword\">FROM<\/span> \n   cities \n<span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">id<\/span> = <span class=\"hljs-number\">1<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this tutorial, you&#8217;ve learned different forms of the MySQL <code>REPLACE<\/code> statement to insert or update data in a table.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful? <\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"13766\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/\"\n\t\t\t\tdata-post-title=\"MySQL REPLACE\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"13766\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/\"\n\t\t\t\tdata-post-title=\"MySQL REPLACE\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary: in this tutorial, you will learn how to use the MySQL REPLACE statement to insert or update data in database tables. Introduction to MySQL REPLACE statement The MySQL REPLACE statement is an extension to the SQL Standard. The MySQL REPLACE statement works as follows: Step 1. Insert a new row into the table, if [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":174,"menu_order":61,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-13766","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL REPLACE<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn how to use the MySQL REPLACE statement to insert data into a table or update existing data of a table.\" \/>\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.mysqltutorial.org\/mysql-basics\/mysql-replace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL REPLACE\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how to use the MySQL REPLACE statement to insert data into a table or update existing data of a table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-29T08:06:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table.png\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/\",\"name\":\"MySQL REPLACE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/MySQL-REPLACE-sample-table.png\",\"datePublished\":\"2023-12-29T08:06:22+00:00\",\"dateModified\":\"2023-12-29T08:06:23+00:00\",\"description\":\"In this tutorial, you will learn how to use the MySQL REPLACE statement to insert data into a table or update existing data of a table.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/MySQL-REPLACE-sample-table.png\",\"contentUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/MySQL-REPLACE-sample-table.png\",\"width\":205,\"height\":81,\"caption\":\"MySQL REPLACE - sample table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-replace\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Basics\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL REPLACE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL REPLACE","description":"In this tutorial, you will learn how to use the MySQL REPLACE statement to insert data into a table or update existing data of a table.","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.mysqltutorial.org\/mysql-basics\/mysql-replace\/","og_locale":"en_US","og_type":"article","og_title":"MySQL REPLACE","og_description":"In this tutorial, you will learn how to use the MySQL REPLACE statement to insert data into a table or update existing data of a table.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/","og_site_name":"MySQL Tutorial","article_modified_time":"2023-12-29T08:06:23+00:00","og_image":[{"url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table.png","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/","url":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/","name":"MySQL REPLACE","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/#primaryimage"},"image":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table.png","datePublished":"2023-12-29T08:06:22+00:00","dateModified":"2023-12-29T08:06:23+00:00","description":"In this tutorial, you will learn how to use the MySQL REPLACE statement to insert data into a table or update existing data of a table.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/#primaryimage","url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table.png","contentUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2019\/09\/MySQL-REPLACE-sample-table.png","width":205,"height":81,"caption":"MySQL REPLACE - sample table"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-replace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Basics","item":"https:\/\/www.mysqltutorial.org\/mysql-basics\/"},{"@type":"ListItem","position":3,"name":"MySQL REPLACE"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/13766","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=13766"}],"version-history":[{"count":2,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/13766\/revisions"}],"predecessor-version":[{"id":13768,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/13766\/revisions\/13768"}],"up":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/174"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=13766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}