{"id":607,"date":"2021-02-05T13:59:20","date_gmt":"2021-02-05T08:29:20","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=607"},"modified":"2022-09-17T12:45:37","modified_gmt":"2022-09-17T07:15:37","slug":"mysql-insert","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-insert\/","title":{"rendered":"MySQL Insert"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<p><strong>MySQL Insert<\/strong> \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0938\u092e\u094d\u092a\u0942\u0930\u094d\u0923 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u094d\u0932 \u092e\u0947\u0902 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u092a\u094d\u0930\u092f\u093e\u0938 \u0915\u093f\u092f\u093e \u0939\u0948\u0902<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL INSERT INTO (\u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0915\u0930\u0928\u093e)<\/h2>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u091c\u094b \u091f\u0947\u092c\u0932 \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947\u0902 \u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 !<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL Insert Syntax<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">INSERT INTO mytable \n(`column1`, `column2`, `column3`, `column4`, `column5`)\nVALUES\n('Value1', 'Value2', 20.5, '2020-02-19', 'Value5');<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Single Quote<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u092c \u0915\u0930\u0947 \u0914\u0930 \u0915\u092c \u0928\u0939\u0940\u0902 ? <\/h3>\n\n\n\n<p><strong>MySQL Insert Statement<\/strong> \u092e\u0947\u0902 \u092f\u0926\u093f \u0915\u093f\u0938\u0940 \u0938\u0947 Mistake \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 \u092f\u0939 \u0939\u0948\u0902 \u0915\u0940 <strong>Single Quote<\/strong> \u0915\u093e \u0938\u0939\u0940 \u091c\u0917\u0939 \u092a\u0930 \u0909\u092a\u092f\u094b\u0917 \u0928 \u0915\u093f\u092f\u093e \u0939\u094b \u0906\u0907\u092f\u0947 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 <strong>Single Quote<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u092c \u0915\u0930\u0928\u093e \u0939\u0948\u0902<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0926\u093f \u0939\u092e\u093e\u0930\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u093e \u0921\u093e\u091f\u093e \u091f\u093e\u0907\u092a String \/ Character \u0939\u0948\u0902 \u0924\u094b \u0939\u092e\u0947\u0902 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b <strong>Single Quote<\/strong> \u092e\u0947\u0902 \u0926\u0947\u0928\u093e \u0939\u0948\u0902 \u091c\u0948\u0938\u093e \u0906\u092a\u0915\u094b <strong>Value1<\/strong> \u092e\u0947\u0902 \u0926\u093f\u092f\u093e \u0939\u0948\u0902 !<\/li><li>\u092f\u0926\u093f \u0939\u092e\u093e\u0930\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u093e \u0921\u093e\u091f\u093e \u091f\u093e\u0907\u092a <strong>Decimal<\/strong> \u092f\u093e <strong>Number<\/strong> \u0939\u0948\u0902 \u0924\u094b \u092b\u093f\u0930 \u0939\u092e\u0947\u0902 <strong>\u092c\u093f\u0928\u093e Single Quote<\/strong> \u0915\u0947 \u0939\u0940 \u0926\u0947\u0928\u093e \u0939\u0948\u0902 \u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a \u0928\u0947 \u0926\u0947\u0916\u093e \u0939\u094b\u0917\u093e \u0915\u0940 \u0939\u092e\u0928\u0947 <strong>Column3<\/strong> \u0915\u0940 <strong>Value<\/strong> \u092e\u0947\u0902 <strong>20.5<\/strong> \u0926\u093f\u092f\u093e \u0939\u0948\u0902 .<\/li><li>Date (\u0926\u093f\u0928\u093e\u0902\u0915) \u0915\u0947 \u0932\u093f\u090f <strong>Single Quote<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Auto Increment \u092b\u0940\u0932\u094d\u0921 \u092e\u0947\u0902 Value \u0926\u0947 \u092f\u093e \u0928 \u0926\u0947 ?<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0947\u0902 <strong>row_id<\/strong> \u0935\u093e\u0932\u0947 \u0915\u0949\u0932\u092e \u0915\u094b \u092e\u093f\u0915\u0932 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0938\u094d\u091f\u0947\u091f\u092e\u0947\u0902\u091f \u092e\u0947\u0902 \u0907\u0938\u0932\u093f\u090f \u0928\u0939\u0940\u0902 \u0932\u093f\u092f\u093e \u0915\u0940 \u0939\u092e \u091a\u093e\u0939\u0924\u0947 \u0925\u0947 \u0915\u0940 \u0909\u0938 \u0915\u0949\u0932\u092e \u092e\u0947\u0902 \u0905\u092a\u0928\u0947 \u0906\u092a \u0939\u0940 \u0928\u0908 \u0935\u0948\u0932\u094d\u092f\u0942 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b (<strong>row_id<\/strong> \u090f\u0915 \u0911\u091f\u094b \u0907\u0928\u094d\u0915\u094d\u0930\u0940\u092e\u0947\u0902\u091f \u092b\u0940\u0932\u094d\u0921 \u0939\u0948\u0902 ) \u0907\u0938\u0932\u093f\u090f \u092f\u0926\u093f \u0939\u092e\u0947\u0902 \u0909\u0938\u0947 \u092c\u094d\u0932\u0947\u0902\u0915 \u0930\u0916\u0947\u0902\u0917\u0947 \u0924\u094b \u0905\u092a\u0928\u0947 \u0906\u092a \u0928\u0947\u0915\u094d\u0938\u094d\u091f \u0935\u0948\u0932\u094d\u092f\u0942 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b\u0924\u0940 \u091c\u093e\u090f\u0917\u0940 !<\/li><li>\u092f\u0926\u093f \u0939\u092e\u0947\u0902 \u0909\u0938\u0947 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u092e\u0947\u0902 \u0932\u093f\u0916\u0947\u0902\u0917\u0947 \u0924\u094b \u091c\u094b \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u092e\u0947\u0902 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0915\u0930\u0947\u0902\u0917\u0947 \u0935\u0939\u0940 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b\u0917\u0940 !<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Insert Multiple rows<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0939\u092e MySQL Insert \u092e\u0947\u0902 \u090f\u0915 \u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e Row Insert \u0915\u0930\u0935\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e\u00a0<strong>MySQL<\/strong>\u00a0<strong>INSERT INTO SELECT<\/strong>\u00a0\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u0907\u0938\u092e\u0947\u0902\u00a0<strong>OtherTable<\/strong>\u00a0\u0915\u093e \u0921\u093e\u091f\u093e\u00a0<strong><strong>MyTable<\/strong><\/strong>\u00a0\u092e\u0947\u0902 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b \u091c\u093e\u090f\u0917\u093e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">INSERT INTO <strong>MyTable<\/strong> \n(`column1`, `column2`, `column3`, `column4`, `column5`)\nSELECT `column1`, `column2`, `column3`, `column4`, `column5` \nFROM <strong>OtherTable<\/strong>;\n<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/Fl2HQQR8dv0\" target=\"_blank\" rel=\"noopener\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 Insert \/ Update \/ Delete \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 <\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">INSERT INTO ON DUPLICATE KEY UPDATE<\/h2>\n\n\n\n<p>\u092f\u0939 \u092c\u0939\u0941\u0924 \u0915\u092e\u093e\u0932 \u0915\u0940 Query \u0939\u0948\u0902 \u0907\u0938\u0915\u0940 \u0938\u0939\u093e\u092f\u0924\u093e \u0938\u0947 \u0921\u0947\u0935\u0932\u092a\u0930 \u0915\u094b Coding \u0915\u0930\u0928\u093e \u092c\u0939\u0941\u0924 \u0906\u0938\u093e\u0928 \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u0938\u093e\u0925 \u092e\u0947\u0902 Coding Error Free \u092d\u0940 \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 , \u091c\u092c \u0939\u092e\u093e\u0930\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u092a\u094d\u0930\u093e\u0907\u092e\u0930\u0940 \u0915\u0947 \u092c\u0928\u0940 \u0939\u094b \u0914\u0930 \u0939\u092e \u0909\u0938\u092e\u0947 \u0935\u0948\u0932\u094d\u092f\u0942 Insert \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 Same Key \u0915\u0940 \u0924\u094b Primary Key \u0915\u0940 Error \u0906\u0924\u0940 \u0939\u0948\u0902 \u091c\u092c\u0915\u093f \u092f\u0926\u093f \u0939\u092e ON DUPLICATE KEY UPDATE \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947 \u0924\u094b DUPLICATE \u0915\u0940 ERROR \u0906\u0928\u0947 \u092a\u0930 \u0935\u0939 Update Command \u0915\u094b Execute \u0915\u0930 \u0926\u0947\u0917\u093e \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">INSERT INTO <strong>MyTable<\/strong>  (`column1`, `column2`)\nVALUES (`value1`, `value2`)\nON DUPLICATE KEY UPDATE\n    column1 = val1, \n    column2 = val2<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<p>\u0906\u092a\u0928\u0947 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u0926\u0947\u0916\u093e \u0915\u0940 \u0915\u0948\u0938\u0947 <strong>Insert Into MySQL Query<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 Data Insert \u0915\u0930\u0928\u0947 \u0932\u093f\u090f \u0964<\/p>\n\n\n\n<p>\u092f\u0939\u00a0<strong>MySQL Insert Query in PHP<\/strong>\u00a0\u092e\u0947\u0902 \u092d\u0940 \u0907\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0906\u090f\u0917\u0940 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-update\/\">UPDATE TABLE (\u0921\u093e\u091f\u093e \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-delete-truncate\/\">DELETE FROM TABLE (\u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0938\u0947 \u0921\u093e\u091f\u093e \u0915\u094b \u092e\u093f\u091f\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f)<\/a><\/li><li><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.sl.SQL_Logic\" target=\"_blank\" rel=\"noopener\">MySQL \u0938\u093f\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u090f\u0915 \u090f\u0902\u0921\u094d\u0930\u093e\u0907\u0921 \u090f\u092a\u094d\u092a \u092d\u0940 \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/Php\/mysql\/\">MYSQL Code \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u0926\u0947\u0916\u0947<\/a><\/li><\/ul>\n\n\n\n<p>\u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0906\u092a\u0915\u094b \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947\u0902 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u092f\u0947, \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Insert \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0938\u092e\u094d\u092a\u0942\u0930\u094d\u0923 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u094d\u0932 \u092e\u0947\u0902 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u092a\u094d\u0930\u092f\u093e\u0938 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 MySQL INSERT INTO (\u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0915\u0930\u0928\u093e) \u0939\u092e\u0928\u0947 \u091c\u094b \u091f\u0947\u092c\u0932 \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947\u0902 \u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 ! MySQL Insert Syntax Single Quote \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u092c \u0915\u0930\u0947 \u0914\u0930 \u0915\u092c \u0928\u0939\u0940\u0902 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":655,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/02\/mysql-insert-into-imagination.png?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":23,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/607\/revisions"}],"predecessor-version":[{"id":9209,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/607\/revisions\/9209"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/655"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}