{"id":609,"date":"2021-02-05T07:07:00","date_gmt":"2021-02-05T01:37:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=609"},"modified":"2022-11-13T18:33:21","modified_gmt":"2022-11-13T13:03:21","slug":"mysql-table-create-alter-drop","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/","title":{"rendered":"MySQL Table"},"content":{"rendered":"\n<p>MySQL Create Table \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0940 \u0915\u092e\u093e\u0902\u0921 \u0939\u0948\u0902, DDL\u00a0Type \u0915\u0940 \u0915\u092e\u093e\u0902\u0921 \u092e\u0947\u0902 CREATE, ALTER, DROP \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u0915\u0935\u0930 \u0915\u0940 \u0917\u0908 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MySQL Create Table<\/strong> (\u091f\u0947\u092c\u0932 \u092c\u0928\u093e\u0928\u093e)<\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 \u0921\u093e\u091f\u093e\u092c\u0947\u0938 \u092e\u0947\u0902 \u091c\u094b \u0921\u093e\u091f\u093e \u0915\u094b \u0938\u094d\u091f\u094b\u0930 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u091f\u0947\u092c\u0932 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902,&nbsp; \u091f\u0947\u092c\u0932 \u0915\u094b \u0905\u0932\u0917 \u0905\u0932\u0917 \u0928\u093e\u092e \u0938\u0947 \u092d\u0940 \u092c\u094b\u0932\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 ! \u091c\u0948\u0938\u0947 (Table, Relation Etc. )<\/p>\n\n\n\n<p>\u0906\u092a \u0917\u094d\u0930\u093e\u092b\u093c\u093f\u0915\u094d\u0938 \u0907\u0902\u091f\u0930\u092b\u093c\u0947\u0938 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 \u092d\u0940 \u091f\u0947\u092c\u0932 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0915\u092e\u093e\u0902\u0921 \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092d\u0940<\/p>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a \u090f\u0915 \u092c\u0922\u093c\u093f\u092f\u093e \u0921\u0947\u0935\u0932\u092a\u0930 \u092c\u0928\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0917\u094d\u0930\u093e\u092b\u093c\u093f\u0915\u094d\u0938 \u0915\u0947 \u092c\u091c\u093e\u092f\u0947 \u0915\u092e\u093e\u0902\u0921 \u0932\u093e\u0907\u0928 \u0938\u0947 \u0938\u094d\u091f\u093e\u0930\u094d\u091f\u093f\u0902\u0917 \u092e\u0947\u0902 \u092a\u094d\u0930\u0948\u0915\u094d\u091f\u093f\u0938 \u0915\u0930\u0928\u093e \u092c\u0922\u093c\u093f\u092f\u093e \u0939\u0948\u0902 , \u092c\u093e\u0926 \u092e\u0947\u0902 \u0906\u092a \u0917\u094d\u0930\u093e\u092b\u093c\u093f\u0915\u094d\u0938 \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092d\u0940 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 !<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Create Table SQL<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE mytable\n(\nrow_id INT(9) NOT NULL AUTO_INCREMENT,\ncolumn1 CHAR(40),\ncolumn2 CHAR(40),\ncolumn3 DECIMAL(9,2),\ncolumn4 DATE,\nPRIMARY KEY (`row_id`)\n);<\/code><\/pre>\n\n\n\n<p>\u092f\u0939 Syntax \u0932\u093f\u0916\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b Execute Query \u092f\u093e F9 Key \u092a\u094d\u0930\u0947\u0938 \u0915\u0930\u0915\u0947 Execute \u0915\u0930\u0928\u093e \u0939\u0948\u0902, \u092f\u0926\u093f \u0915\u094b\u0908 \u0938\u093f\u0902\u091f\u0947\u0915\u094d\u0938 \u090f\u0930\u0930 \u0928\u0939\u0940\u0902 \u0939\u0941\u090f \u0924\u094b<br><strong>queries executed, 1 success,<\/strong><br>\u092e\u0948\u0938\u0947\u091c Messages \u0935\u093e\u0932\u0947 \u091f\u0948\u092c \u092e\u0947\u0902 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e !<\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/CadqqXZVsoI\" data-type=\"URL\" data-id=\"https:\/\/youtu.be\/CadqqXZVsoI\" target=\"_blank\" rel=\"noopener\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 Table \u092c\u0928\u093e\u0928\u093e \u0938\u0940\u0916\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\">ALTER TABLE MySQL<\/h2>\n\n\n\n<p>Alter Table \u092e\u0947\u0902 3 \u0911\u092a\u094d\u0936\u0928 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MySQL Add Column (Alter Table Add)<\/li>\n\n\n\n<li>Alter Table Modify<\/li>\n\n\n\n<li>Alter Table Drop<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL Add Column (\u091f\u0947\u092c\u0932 \u0915\u0947 \u0938\u094d\u091f\u094d\u0930\u0915\u094d\u091a\u0930 \u092e\u0947\u0902 \u0915\u0949\u0932\u092e \u0910\u0921 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f)<\/h3>\n\n\n\n<p>\u0907\u0938\u0947 alter table add column \u092d\u0940 \u092c\u094b\u0932\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0928\u093f\u092e\u094d\u0928 \u0915\u092e\u093e\u0902\u0921 \u0926\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"><strong>ALTER TABLE mytable ADD column5 CHAR(40);<\/strong><\/code><\/pre>\n\n\n\n<p>\u092f\u0939\u093e\u0901 \u092a\u0930 \u092a\u0939\u0932\u0947 \u0938\u0947 \u092c\u0928\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u090f\u0915 \u0915\u0949\u0932\u092e \u0914\u0930 \u0910\u0921 \u0915\u093f\u092f\u093e \u0939\u0948\u0902<\/p>\n\n\n\n<p>ADD &#8211; \u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e\u0947\u0902 \u091c\u094b \u092d\u0940 \u0915\u0949\u0932\u092e \u0910\u0921 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0939\u092e \u0909\u0938\u0915\u093e \u0928\u093e\u092e \u0914\u0930 \u0921\u093e\u091f\u093e \u091f\u093e\u0907\u092a \u0935&nbsp; \u0921\u093e\u091f\u093e \u0915\u0940 \u0938\u093e\u0907\u091c \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL Add Column &#8211; ALTER TABLE (MODIFY)&nbsp; \u091f\u0947\u092c\u0932 \u0915\u0947 \u0915\u0949\u0932\u092e \u0915\u0947 \u0938\u094d\u091f\u094d\u0930\u0915\u094d\u091a\u0930 \u0915\u094b \u092c\u0926\u0932\u0928\u093e<\/h3>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"><strong>ALTER TABLE mytable MODIFY column5 CHAR(20);<\/strong><\/code><\/pre>\n\n\n\n<p>\u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0938\u0947 \u0939\u092e \u092a\u0939\u0932\u0947 \u0938\u0947 \u092c\u0928\u0947 \u0915\u0949\u0932\u092e \u0915\u0940 \u0938\u094d\u091f\u094d\u0930\u0915\u094d\u091a\u0930 \u0915\u094b \u091a\u0947\u0902\u091c \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 !<br>\u091c\u0948\u0938\u0947 \u091c\u094b \u0939\u092e\u0928\u0947 \u092a\u0939\u0932\u0947 Coloum5 CHAR(40) \u0910\u0921 \u0915\u093f\u092f\u093e \u0925\u093e , \u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0938\u0947 \u0939\u092e\u0928\u0947 \u0909\u0938\u0947 CHAR(20) \u0915\u0930 \u0926\u093f\u092f\u093e !<br>\u0926\u094b\u0938\u094d\u0924\u094b\u0902, \u092f\u0939\u093e\u0901 \u092a\u0930 \u0927\u094d\u092f\u093e\u0928 \u0926\u0947\u0928\u0947 \u0935\u093e\u0932\u0940 \u092c\u093e\u0924 \u092f\u0939 \u0939\u0948\u0902 \u0915\u0940 , \u0915\u092d\u0940 \u092d\u0940 \u0915\u093f\u0938\u0940 \u092d\u0940 \u0915\u0949\u0932\u092e \u0915\u0940 \u0935\u093f\u0921\u094d\u0925 \u0915\u094b \u0921\u093e\u091f\u093e \u090f\u0902\u091f\u0930 \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0915\u092e \u0928\u0939\u0940\u0902 \u0915\u0930\u0928\u093e, \u0915\u094d\u092f\u0941\u0915\u0940 \u0921\u093e\u091f\u093e \u0932\u0949\u0938 \u0939\u094b\u0928\u0947 \u0915\u0947 \u091a\u093e\u0902\u0938 \u0930\u0939\u0924\u0947 \u0939\u0948\u0902 !<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER TABLE DROP&nbsp; \u091f\u0947\u092c\u0932 \u0915\u0947 \u0915\u0949\u0932\u092e \u0915\u094b \u0921\u093f\u0932\u0940\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/h3>\n\n\n\n<p class=\"\">\u092f\u0926\u093f \u0939\u092e \u0915\u093f\u0938\u0940 \u090f\u0915 \u092f\u093e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u0915\u0949\u0932\u092e \u0915\u094b \u0921\u093f\u0932\u0940\u091f \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u0928\u093f\u092e\u094d\u0928 \u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"><strong>ALTER TABLE mytable DROP column5;<\/strong>\n<strong>ALTER TABLE mytable DROP column4, column5;<\/strong><\/code><\/pre>\n\n\n\n<p class=\"\"> <\/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<h2 class=\"wp-block-heading\">DROP TABLE (\u091f\u0947\u092c\u0932 \u0915\u094b \u0921\u094d\u0930\u093e\u092a \u0915\u0930\u0928\u093e [\u092e\u093f\u091f\u093e\u0928\u093e \u092f\u093e \u0921\u093f\u0932\u0940\u091f \u0915\u0930\u0928\u093e])<\/h2>\n\n\n\n<p class=\"\">\u091f\u0947\u092c\u0932 \u0915\u094b \u0921\u093f\u0932\u0940\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f DROP&nbsp;TABLE \u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DROP TABLE mytable;<\/code><\/pre>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0915\u092e\u093e\u0902\u0921 \u0915\u094b Execute \u0915\u0930\u0928\u0947 \u092a\u0930 \u092f\u0939 \u092e\u0948\u0938\u0947\u091c \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e !<\/p>\n\n\n\n<p><strong>1 queries executed, 1 success, 0 errors, 0 warnings<\/strong><\/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\">\u0938\u0940\u0916\u0947 VIDEO \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0938\u0930\u0932 \u092d\u093e\u0937\u093e \u092e\u0947 Programming \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f&nbsp;<a href=\"https:\/\/www.youtube.com\/channel\/UCHLuWJ4xcq70qvWgog4YSrg\" target=\"_blank\" rel=\"noreferrer noopener\">Imagination Code Channel<\/a>&nbsp;\u0915\u094b Subscribe \u0915\u0930\u0947\u0964<\/li>\n\n\n\n<li><a href=\"https:\/\/t.me\/tutorialforlearnmysql\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Telegram Channel<\/a>&nbsp;\u0938\u0947 \u091c\u0941\u0921\u093c\u0947 \u0914\u0930 \u092a\u093e\u090f Article &amp; Video \u092a\u094d\u0930\u0924\u093f\u0926\u0940\u0928<\/li>\n\n\n\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=dwKr33RG3UA&amp;list=PLhJ6tQK0qIcOLAiCWg00L79euGSNVoVno\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Beginner &amp; Advance Playlist in Hindi<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/dwKr33RG3UA\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Overview in One Video<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/KtajC0R3-d8\" target=\"_blank\" rel=\"noopener\">MySQL Temporary Table (Create, Copy Structure, Copy Data)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/F7qeUTG6Uto\" target=\"_blank\" rel=\"noopener\">MySQL Copy \/ Clone Table Using LIKE &amp; Select<\/a><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"\">\u092f\u0926\u093f \u0906\u092a \u0911\u0928\u0932\u093e\u0907\u0928 SQL \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e\u0947\u0902 \u0915\u092e\u0947\u0902\u091f \u0915\u0930\u0947 \u0964 <\/p>\n\n\n\n<p class=\"\"><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.sl.SQL_Logic\" target=\"_blank\" rel=\"noopener\">\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><\/p>\n\n\n\n<p class=\"\"><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> <\/p>\n\n\n\n<p class=\"\">\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","protected":false},"excerpt":{"rendered":"<p>MySQL Create Table \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0940 \u0915\u092e\u093e\u0902\u0921 \u0939\u0948\u0902, DDL\u00a0Type \u0915\u0940 \u0915\u092e\u093e\u0902\u0921 \u092e\u0947\u0902 CREATE, ALTER, DROP \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u0915\u0935\u0930 \u0915\u0940 \u0917\u0908 \u0939\u0948\u0902 \u0964 MySQL Create Table (\u091f\u0947\u092c\u0932 \u092c\u0928\u093e\u0928\u093e) \u0915\u093f\u0938\u0940 \u092d\u0940 \u0921\u093e\u091f\u093e\u092c\u0947\u0938 \u092e\u0947\u0902 \u091c\u094b \u0921\u093e\u091f\u093e \u0915\u094b \u0938\u094d\u091f\u094b\u0930 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u091f\u0947\u092c\u0932 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902,&nbsp; \u091f\u0947\u092c\u0932 \u0915\u094b \u0905\u0932\u0917 \u0905\u0932\u0917 \u0928\u093e\u092e \u0938\u0947 \u092d\u0940 \u092c\u094b\u0932\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 ! [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":636,"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-609","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-Table-imagination.png?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/609","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=609"}],"version-history":[{"count":14,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/609\/revisions"}],"predecessor-version":[{"id":9522,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/609\/revisions\/9522"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/636"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}