{"id":8551,"date":"2022-07-06T16:27:12","date_gmt":"2022-07-06T10:57:12","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=8551"},"modified":"2022-09-17T12:49:53","modified_gmt":"2022-09-17T07:19:53","slug":"from-clause-in-myql","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/from-clause-in-myql\/","title":{"rendered":"FROM Clause in MySQL (Hindi)"},"content":{"rendered":"\n<p>MySQL \u092e\u0947 From \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e\u0947 Table \/ View \/ Subquery \u0915\u093e \u0928\u093e\u092e \u0926\u0947\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902, \u0915\u092e \u0938\u0947 \u0915\u092e \u090f\u0915 Table\/View\/Sub Query \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0914\u0930 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u0939\u092e \u0915\u093f\u0924\u0928\u0947 \u0939\u0940 \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u092f\u0939 \u0938\u0902\u0916\u094d\u092f\u093e \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092a\u0930 \u0928\u093f\u0930\u094d\u092d\u0930 \u0915\u0930\u0924\u0940 \u0939\u0948\u0902 \u0964 \u0907\u0938 Example \u092e\u0947 \u0939\u092e MySQL FROM \u0915\u0947 \u0938\u093e\u0925 Table, VIew, Multiple Tables, Subquery, Dummy Table \u0915\u093e \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 , \u0907\u0938\u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0947\u0902\u0917\u0947 ,    <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>FROM Table Name<\/li><li>FROM View<\/li><li>FROM Multiple Tables <\/li><li>FROM Sub Queriy<\/li><li>FROM Dummy Tables<\/li><\/ul>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/WiCErTxwK5c\" target=\"_blank\" rel=\"noopener\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \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-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FROM &lt;Table Name&gt;<\/h2>\n\n\n\n<p>From \u0915\u0947 \u092c\u093e\u0926 Table \u0915\u093e \u0928\u093e\u092e \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0915\u0941\u091b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM MyTable<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/select-example\/\">Select Clause \u0915\u0947 Multiple \u0909\u092a\u092f\u094b\u0917 \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Click \u0915\u0930\u0947 \u0964 <\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FROM &lt;View Name&gt;<\/h2>\n\n\n\n<p>From \u0915\u0947 \u092c\u093e\u0926 View \u0915\u093e \u0928\u093e\u092e bhi \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0915\u0941\u091b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM MyView<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FROM &lt;Multiple Tables&gt;<\/h2>\n\n\n\n<p>\u091c\u092c \u0906\u092a\u0915\u094b \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Tables \u0938\u0947 data \u0932\u0947\u0928\u093e \u0939\u094b \u0924\u092c \u0906\u092a Comma \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Table \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, Coding \u0915\u094b \u0906\u0938\u093e\u0928 \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a Alias \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947 , Alias \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 Short Name \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT a.*, b.Col1, C.Col2 \nFROM MyTable1 a, MyTable2 b, MyView c   \nWhere &lt;Table Join Condition&gt;\n<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/QHoGHcV0uqM\" target=\"_blank\" rel=\"noopener\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Click \u0915\u0930\u0947 \u0964 <\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FROM Sub Query<\/h2>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u091c\u094b \u092d\u0940 Query \u092a\u0939\u0932\u0947 \u0938\u0947 \u0932\u093f\u0916\u0940 \u0939\u094b \u0913\u0930 \u0939\u092e \u0909\u0938\u0915\u0947 result \u092a\u0930 \u092d\u0940 \u0915\u094b\u0908 Query \u0932\u093f\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0909\u0938\u0947 Sub Query \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT MyCol FROM\n(\n    SELECT col1 AS MyCol \n    FROM MyTable1 a \n    WHERE ......\n) b\nWHERE ......\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FROM Dummy Tables<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0939\u092e\u0947 \u0915\u094b\u0908 \u0921\u092e\u0940 \u091f\u0947\u092c\u0932 \u092c\u0928\u093e\u0928\u093e \u0939\u094b \u0914\u0930 \u0909\u0938 \u092a\u0930 \u092d\u0940 \u0915\u094b\u0908 operation \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT MyCol FROM\n(\n    SELECT '1' AS MyCol \n    UNION ALL SELECT '2' AS MyCol \n    UNION ALL SELECT '3' AS MyCol \n    UNION ALL SELECT '4' AS MyCol \n) a<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e-\u0930-\u0905\u0928-\u092f-\u0906\u0930-\u091f-\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>\u00a0<\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \u092e\u0947 From \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e\u0947 Table \/ View \/ Subquery \u0915\u093e \u0928\u093e\u092e \u0926\u0947\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902, \u0915\u092e \u0938\u0947 \u0915\u092e \u090f\u0915 Table\/View\/Sub Query \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0914\u0930 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u0939\u092e \u0915\u093f\u0924\u0928\u0947 \u0939\u0940 \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u092f\u0939 \u0938\u0902\u0916\u094d\u092f\u093e \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092a\u0930 \u0928\u093f\u0930\u094d\u092d\u0930 \u0915\u0930\u0924\u0940 \u0939\u0948\u0902 \u0964 \u0907\u0938 Example \u092e\u0947 \u0939\u092e MySQL FROM \u0915\u0947 \u0938\u093e\u0925 Table, VIew, Multiple Tables, Subquery, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8741,"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-8551","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\/2022\/07\/mysql-from-clause.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8551","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=8551"}],"version-history":[{"count":37,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8551\/revisions"}],"predecessor-version":[{"id":9213,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8551\/revisions\/9213"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/8741"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=8551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=8551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=8551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}