{"id":5957,"date":"2015-01-30T23:59:14","date_gmt":"2015-01-31T04:59:14","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5957"},"modified":"2015-09-03T08:10:38","modified_gmt":"2015-09-03T12:10:38","slug":"sql-default-%e0%a6%a1%e0%a6%bf%e0%a6%ab%e0%a6%b2%e0%a7%8d%e0%a6%9f-constraint-sql-default-constraint","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5957","title":{"rendered":"SQL default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint . SQL Default Constraint"},"content":{"rendered":"<p>SQL default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint<br \/>\nRIAZ-UL-HAQUE MIAN<br \/>\n\u099f\u09c7\u09ac\u09bf\u09b2 \u098f \u09af\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u09a8\u09a4\u09c1\u09a8 \u09ad\u09cd\u09af\u09be\u09b2\u09c1 insert \u0995\u09b0\u09be \u09b9\u09df \u09a4\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u0995\u09cb\u09a8\u09cb \u09ab\u09bf\u09b2\u09cd\u09a1 \u098f \u09ab\u09bf\u0995\u09cd\u09b8\u09a1 \u0995\u09cb\u09a8\u09cb \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u09b8\u09c7\u099f \u0995\u09b0\u09a4\u09c7 \u09b9\u09b2\u09c7 default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 | \u09af\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u09a8\u09bf\u0989 \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f insert \u0995\u09b0\u09be \u09b9\u09ac\u09c7 \u09a4\u0996\u09a8 default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u099f\u09bf row insert \u09b8\u09be\u09a5\u09c7 insert \u09b9\u09df\u09c7 \u09af\u09be\u09ac\u09c7 |<br \/>\n\u098f\u0996\u09a8 \u0986\u09ae\u09b0\u09be \u09a6\u09c7\u0996\u09ac \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09c0 \u0995\u09b0\u09be\u09b0 \u09b8\u09ae\u09df \u0995\u09bf \u09ad\u09be\u09ac\u09c7 \u09b8\u09c7\u099f \u0995\u09b0\u09c7 | \u0989\u09a7\u09be\u09b0\u09a3 \u09b8\u09b0\u09c2\u09aa \u0986\u09ae\u09b0\u09be Persons Table \u098f\u09b0 city (\u09b8\u09bf\u099f\u09bf) \u0995\u09b2\u09be\u09ae \u098f \u09b8\u09ac \u09b8\u09ae\u09df Dhaka (\u09a2\u09be\u0995\u09be) \u09b8\u09c7\u099f \u0995\u09b0\u09a4\u09c7 \u099a\u09be\u0987 \u09b8\u09c7\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 SQL syntax \u09b9\u09ac\u09c7 :<br \/>\nCREATE TABLE Persons<br \/>\n(<br \/>\nP_Id int NOT NULL,<br \/>\nLastName varchar(255) NOT NULL,<br \/>\nFirstName varchar(255),<br \/>\nAddress varchar(255),<br \/>\nCity varchar(255) DEFAULT &#8216;Dhaka&#8217;<br \/>\n)<br \/>\ndefault (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u098f SQL server function \u0993 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df \u09af\u09c7\u09ae\u09a8<br \/>\nCREATE TABLE Orders<br \/>\n(<br \/>\nO_Id int NOT NULL,<br \/>\nOrderNo int NOT NULL,<br \/>\nP_Id int,<br \/>\nOrderDate date DEFAULT GETDATE()<br \/>\n)<br \/>\n\u098f\u09a4\u09cd\u09a4\u0995\u09cd\u09b7\u09a8 \u0986\u09ae\u09b0\u09be \u09a6\u09c7\u0996\u09b2\u09be\u09ae \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u098f\u0995\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09c0 \u0995\u09b0\u09be\u09b0 \u09b8\u09ae\u09df default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u09b8\u09c7\u099f \u0995\u09b0\u09c7\u0964 \u098f\u09ac\u09be\u09b0 \u09ae\u09a8\u09c7 \u0995\u09b0\u09bf Persons \u099f\u09c7\u09ac\u09bf\u09b2 \u099f\u09bf \u0986\u0997\u09c7 \u09a5\u09be\u0995\u09c7 \u0987 \u09a4\u09c8\u09b0\u09c0 \u0995\u09b0\u09be \u0986\u099b\u09c7 \u098f\u0996\u09a8 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u0995\u09c7 city column \u098f\u09b0 \u09a1\u09bf\u09ab\u09b2\u09cd\u099f \u09ad\u09cd\u09af\u09be\u09b2\u09c1 Dhaka (\u09a2\u09be\u0995\u09be) \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u098f\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u0986\u09ae\u09b0\u09be \u0985\u09b2\u09cd\u099f\u09be\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2 statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac<br \/>\nMySQL:<br \/>\nALTER TABLE Persons<br \/>\nALTER City SET DEFAULT &#8216;SANDNES&#8217;<br \/>\nSQL Server \/ MS Access:<br \/>\nALTER TABLE Persons<br \/>\nALTER COLUMN City SET DEFAULT &#8216;SANDNES&#8217;<br \/>\nOracle:<br \/>\nALTER TABLE Persons<br \/>\nMODIFY City DEFAULT &#8216;SANDNES&#8217;<\/p>\n<p>\u09b8\u09ac \u09b6\u09c7\u09b7\u09c7 \u09a6\u09c7\u0996\u09ac \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u0995\u09c7 default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u09b0\u09bf\u09ae\u09c1\u09ad \u0995\u09b0\u09c7 \u0964 \u098f\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 MySQL \u0993 SQL Server \/ Oracle \/ MS Access SQL starement \u09a8\u09bf\u099a\u09c7 \u09a6\u09bf\u09df\u09be \u09b9\u09b2\u09cb<br \/>\nMySQL \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 query \u099f\u09bf \u09b9\u09ac\u09c7 \u09a8\u09bf\u09a8\u09cd\u09ae\u09b0\u09c2\u09aa :<br \/>\nALTER TABLE Persons<br \/>\nALTER City DROP DEFAULT<br \/>\n\u0986\u09b0 SQL Server \/ Oracle \/ MS Access \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 quraery \u099f\u09bf \u09b9\u09ac\u09c7 \u09a8\u09bf\u09a8\u09cd\u09ae\u09b0\u09c2\u09aa :<br \/>\nALTER TABLE Persons<br \/>\nALTER COLUMN City DROP DEFAULT<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint RIAZ-UL-HAQUE MIAN \u099f\u09c7\u09ac\u09bf\u09b2 \u098f \u09af\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u09a8\u09a4\u09c1\u09a8 \u09ad\u09cd\u09af\u09be\u09b2\u09c1 insert \u0995\u09b0\u09be \u09b9\u09df \u09a4\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u0995\u09cb\u09a8\u09cb \u09ab\u09bf\u09b2\u09cd\u09a1 \u098f \u09ab\u09bf\u0995\u09cd\u09b8\u09a1 \u0995\u09cb\u09a8\u09cb \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u09b8\u09c7\u099f \u0995\u09b0\u09a4\u09c7 \u09b9\u09b2\u09c7 default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 | \u09af\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u09a8\u09bf\u0989 \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f insert \u0995\u09b0\u09be \u09b9\u09ac\u09c7 \u09a4\u0996\u09a8 default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u099f\u09bf row insert \u09b8\u09be\u09a5\u09c7 insert \u09b9\u09df\u09c7 \u09af\u09be\u09ac\u09c7 &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=5957\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[155],"tags":[],"class_list":["post-5957","post","type-post","status-publish","format-standard","hentry","category------sql-001","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5937,"url":"http:\/\/bangla.sitestree.com\/?p=5937","url_meta":{"origin":5957,"position":0},"title":"SQL \u09a1\u09bf\u09ab\u09b2\u09cd\u099f Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL \u09a1\u09bf\u09ab\u09b2\u09cd\u099f Constraint NAZMA AKHRET \u099f\u09c7\u09ac\u09bf\u09b2 \u098f \u09af\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u09a8\u09a4\u09c1\u09a8 \u09ad\u09cd\u09af\u09be\u09b2\u09c1 insert \u0995\u09b0\u09be \u09b9\u09df \u09a4\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u0995\u09cb\u09a8\u09cb \u09ab\u09bf\u09b2\u09cd\u09a1 \u098f \u09ab\u09bf\u0995\u09cd\u09b8\u09a1 \u0995\u09cb\u09a8\u09cb \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u09b8\u09c7\u099f \u0995\u09b0\u09a4\u09c7 \u09b9\u09b2\u09c7 default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 | \u09af\u0996\u09a8 \u0995\u09cb\u09a8\u09cb \u09a8\u09bf\u0989 \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f insert \u0995\u09b0\u09be \u09b9\u09ac\u09c7 \u09a4\u0996\u09a8 default (\u09a1\u09bf\u09ab\u09b2\u09cd\u099f) Constraint \u099f\u09bf row insert\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5949,"url":"http:\/\/bangla.sitestree.com\/?p=5949","url_meta":{"origin":5957,"position":1},"title":"SQL \u0987\u0989\u09a8\u09bf\u0995 Constraint  . SQL Unique Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL \u0987\u0989\u09a8\u09bf\u0995 Constraint RIAZ-UL-HAQUE MIAN \u0987\u0989\u09a8\u09bf\u0995 Constraint \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09af\u09c7\u0995\u09cb\u09a8\u09cb \u098f\u0995\u099f\u09bf \u0995\u09b2\u09be\u09ae \u098f\u09b0 \u09b8\u09cd\u09ac\u09a4\u09a8\u09cd\u09a4\u09cd\u09b0\u09a4\u09be\/ uniqueness \u0995\u09c7 \u09ac\u09c1\u099d\u09be\u09df . \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf \u0995\u09bf \u09b8\u09c7\u099f \u0995\u09b0\u09b2\u09c7 \u09a4\u09be automatically \u0987\u0989\u09a8\u09bf\u0995 Constraint \u09b9\u09df\u09c7 \u09af\u09be\u09df\u0964 \u09a4\u09be\u09b9\u09b2\u09c7 \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8 \u09b9\u09b2\u09cb \u0987\u0989\u09a8\u09bf\u0995 Constraint \u09a6\u09b0\u0995\u09be\u09b0 \u0995\u09bf ? \u0995\u09be\u09b0\u09a3 \u0986\u09aa\u09a8\u09bf \u098f\u0995\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u098f\u0995\u099f\u09be \u09ae\u09be\u09a4\u09cd\u09b0 \u0995\u09b2\u09be\u09ae \u0995\u09c7 \u0987 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5931,"url":"http:\/\/bangla.sitestree.com\/?p=5931","url_meta":{"origin":5957,"position":2},"title":"SQL \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf Constraint . SQL Primary Key Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf Constraint RIAZ-UL-HAQUE MIAN \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf Constraint \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09af\u09c7\u0995\u09cb\u09a8\u09cb \u098f\u0995\u099f\u09bf \u0995\u09b2\u09be\u09ae \u098f\u09b0 \u09b8\u09cd\u09ac\u09a4\u09a8\u09cd\u09a4\u09cd\u09b0\u09a4\u09be\/ uniqueness \u0995\u09c7 \u09ac\u09c1\u099d\u09be\u09df . \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf \u0995\u09bf \u0985\u09ac\u09b6\u0987 \u0987\u0989\u09a8\u09bf\u0995 \u09b9\u09a4\u09c7 \u09b9\u09ac\u09c7 \u098f\u09ac\u0982 NULL \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7\u09a8\u09be . \u09aa\u09cd\u09b0\u09a4\u09bf\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u098f \u0987 \u098f\u0995\u099f\u09be \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf key \u09a5\u09be\u0995\u09be \u0989\u099a\u09c0\u09a0 \u098f\u0995\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u098f\u0995\u099f\u09be \u09ae\u09be\u09a4\u09cd\u09b0 \u0995\u09b2\u09be\u09ae \u0995\u09c7 \u0987 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5951,"url":"http:\/\/bangla.sitestree.com\/?p=5951","url_meta":{"origin":5957,"position":3},"title":"SQL \u098f\u09b0 PRIMARY KEY \u09a4\u09a5\u09be \u09aa\u09cd\u09b0\u09be\u09a5\u09ae\u09bf\u0995 \u099a\u09be\u09ac\u09bf \u098f\u09b0 \u09ac\u09be\u09a7\u09cd\u09af\u09ac\u09be\u09a6\u0995\u09a4\u09be\u0964SQL Primary Key Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL \u098f\u09b0 PRIMARY KEY \u09a4\u09a5\u09be \u09aa\u09cd\u09b0\u09be\u09a5\u09ae\u09bf\u0995 \u099a\u09be\u09ac\u09bf \u098f\u09b0 \u09ac\u09be\u09a7\u09cd\u09af\u09ac\u09be\u09a6\u0995\u09a4\u09be\u0964 \u09ab\u09be\u099b\u09bf\u09b9\u09c1\u09b0 \u09b0\u09b9\u09ae\u09be\u09a8\u0964 MSCSE From Royal University of Dhaka. \u099f\u09c7\u0995\u09a8\u09bf\u0995\u09cd\u09af\u09be\u09b0 \u098f\u0995\u09cd\u09b8\u09aa\u09be\u09b0\u09cd\u099f, \u09ac\u09be\u0982\u09b2\u09be\u09a6\u09c7\u09b6 \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8 \u0995\u09ae\u09bf\u09b6\u09a8 \u09b8\u099a\u09bf\u09ac\u09be\u09b2\u09df\u0964 SQL \u098f\u09b0 \u09aa\u09cd\u09b0\u09be\u09a5\u09ae\u09bf\u0995 \u0995\u09bf \u098f\u09b0 \u09ac\u09be\u09a7\u09cd\u09af\u09ac\u09be\u09a6\u0995\u09a4\u09be\u0964 \u09aa\u09cd\u09b0\u09be\u09a5\u09ae\u09bf\u0995 \u0995\u09bf \u09ac\u09be\u09a7\u09cd\u09af\u09ac\u09be\u09a6\u0995\u09a4\u09be\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09aa\u09cd\u09b0\u09a4\u09cd\u09af\u09c7\u0995\u099f\u09bf Record \u09a4\u09a5\u09be \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u0995\u09c7 \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u09ad\u09be\u09ac\u09c7 \u099a\u09bf\u09a8\u09cd\u09b9\u09bf\u09a4 \u0995\u09b0\u09c7\u0964 \u09aa\u09cd\u09b0\u09be\u09a5\u09ae\u09bf\u0995 \u0995\u09bf \u0985\u09ac\u09b6\u09cd\u09af\u09df \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u09ae\u09be\u09a8 \u09ac\u09b9\u09a8 \u0995\u09b0\u09c7\u0964 \u098f\u0995\u099f\u09bf\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5947,"url":"http:\/\/bangla.sitestree.com\/?p=5947","url_meta":{"origin":5957,"position":4},"title":"SQL Not Null Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae Job category-Php Coder \u09ac\u09bf\u09b7\u09df- SQL Not Null Constraint Null \u098f\u09b0 \u0985\u09b0\u09cd\u09a5 \u0995\u09cb\u09a8 \u099c\u09be\u0987\u0997\u09be \u09ab\u09be\u0995\u09be \u09a5\u09be\u0995\u09be\u0964\u09b8\u09be\u09a7\u09be\u09b0\u09a8\u09a4 \u0995\u09cb\u09a8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09ab\u09bf\u09b2\u09cd\u09a1 \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be \u0995\u09cb\u09a8 \u0995\u09bf\u099b\u09c1 \u09a8\u09be \u0987\u09a8\u09aa\u09c1\u099f \u0995\u09b0\u09c7 \u09a5\u09be\u0995\u09bf \u098f\u09ac\u0982 \u09b8\u09c7\u09ad \u0995\u09b0\u09bf \u09a4\u09be\u09b9\u09b2\u09c7 \u099c\u09be\u0987\u0997\u09be \u099f\u09be \u09ab\u09be\u0995\u09be \u09a5\u09be\u0995\u09c7 \u0995\u09bf\u09a8\u09cd\u09a4\u09c1 mysql database \u098f \u09b8\u09c7\u099f\u09bf\u0982\u09b8\u09cd\u200c \u09a0\u09bf\u0995 \u0995\u09b0\u09c7 \u09a6\u09bf\u09b2\u09c7 \u09b8\u09c7\u0987 \u099c\u09be\u0987\u0997\u09be \u0986\u09ae\u09b0\u09be \u09af\u09a4\u0995\u09cd\u09b7\u09a3 \u09aa\u09b0\u09cd\u09af\u09a8\u09cd\u09a4\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5903,"url":"http:\/\/bangla.sitestree.com\/?p=5903","url_meta":{"origin":5957,"position":5},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Joins","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) UNIQUE \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f Author: Protap Chandra | sincerely.yours2512[at]gmail.com UNIQUE \u0985\u09b0\u09cd\u09a5 \u0985\u09a8\u09a8\u09cd\u09af \u09ac\u09be \u0985\u09a6\u09cd\u09ac\u09bf\u09a4\u09c0\u09df\u0964 \u0985\u09b0\u09cd\u09a5\u09be\u09a4 \u098f\u0995\u0987 \u099c\u09bf\u09a8\u09bf\u09b8 \u09a6\u09c1\u099f\u09bf \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7 \u09a8\u09be\u0964 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u0987\u0989\u09a8\u09bf\u0995 \u09a1\u09be\u099f\u09be \u09b8\u09cd\u099f\u09cb\u09b0 \u0995\u09b0\u09be \u09b9\u09df \u09a1\u09be\u099f\u09be \u09b8\u09be\u09b0\u09cd\u099a \u0995\u09b0\u09be\u09b0 \u09b8\u09ae\u09df \u09ac\u09bf\u09ad\u09cd\u09b0\u09be\u09a8\u09cd\u09a4\u09bf \u098f\u09dc\u09be\u09a4\u09c7\u0964 \u09af\u09c7 \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u09a1\u09be\u099f\u09be \u0987\u0989\u09a8\u09bf\u0995 \u09b9\u09bf\u09b8\u09c7\u09ac\u09c7 \u0998\u09cb\u09b7\u09a3\u09be \u0995\u09b0\u09be \u09b9\u09ac\u09c7 \u09b8\u09c7\u0987 \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u09b0\u09c7\u0995\u09b0\u09cd\u09a1\u09c7\u09b0 \u09b8\u0999\u09cd\u0997\u09c7 \u0985\u09a8\u09cd\u09af \u09b0\u09c7\u0995\u09b0\u09cd\u09a1\u09c7\u09b0\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5957"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5957\/revisions"}],"predecessor-version":[{"id":5958,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5957\/revisions\/5958"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5957"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}