{"id":5910,"date":"2015-01-30T23:25:56","date_gmt":"2015-01-31T04:25:56","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5910"},"modified":"2015-09-03T08:09:12","modified_gmt":"2015-09-03T12:09:12","slug":"%e0%a6%8f%e0%a6%b8%e0%a6%95%e0%a6%bf%e0%a6%89%e0%a6%8f%e0%a6%b2-%e0%a6%ab%e0%a7%81%e0%a6%b2-%e0%a6%86%e0%a6%89%e0%a6%9f%e0%a6%be%e0%a6%b0-%e0%a6%9c%e0%a7%9f%e0%a7%87%e0%a6%a8-%e0%a6%95%e0%a6%bf","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5910","title":{"rendered":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09c1\u09b2 \u0986\u0989\u099f\u09be\u09b0 \u099c\u09df\u09c7\u09a8 \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 . SQL FULL OUTER JOIN Keyword"},"content":{"rendered":"

\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09c1\u09b2 \u0986\u0989\u099f\u09be\u09b0 \u099c\u09df\u09c7\u09a8 \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1
\nSheikh Mahfuzur Rahman<\/p>\n

FULL OUTER JOIN \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09ac\u09be\u09ae \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2(table1) \u098f\u09ac\u0982 \u09a1\u09be\u09a8 \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0(table2) \u09b8\u09ac\u0997\u09c1\u09b2\u09cb \u09b8\u09be\u09b0\u09bf\u0995\u09c7 \u09ab\u09c7\u09b0\u09a4 \u09a6\u09c7\u09df\u0964 FULL OUTER JOIN \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 LEFT \u0993 RIGHT \u0989\u09ad\u09df \u09b8\u0982\u09af\u09cb\u0997-\u09b8\u09cd\u09a5\u09b2\u0995\u09c7\u0987 \u09ae\u09bf\u09b2\u09bf\u09df\u09c7 \u09a6\u09c7\u09df\u0964<\/p>\n

\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 FULL OUTER JOIN \u09b8\u09bf\u09a8\u09cd\u099f\u09c7\u0995\u09cd\u09b8\u099f\u0983
\nSELECT column_name(s)
\nFROM table1
\nFULL OUTER JOIN table2
\nON table1.column_name=table2.column_name;<\/p>\n

\u09a8\u09ae\u09c1\u09a8\u09be \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c
\n\u098f\u0987 \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2\u09c7 \u0986\u09ae\u09b0\u09be \u09b8\u09c1\u09aa\u09b0\u09bf\u099a\u09bf\u09a4 \u09a8\u09b0\u09cd\u09a5\u0989\u0987\u09a8\u09cd\u09a1(Northwind) \u09a8\u09ae\u09c1\u09a8\u09be \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac\u0964 \u09a8\u09bf\u099a\u09c7 “Customers\u201d \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u0985\u0982\u09b6\u0995\u09c7 \u09a4\u09c1\u09b2\u09c7 \u09a7\u09b0\u09be \u09b9\u09df\u09c7\u099b\u09c7\u0983<\/p>\n

CustomerID
\nCustomerName
\nContactName
\nAddress
\nCity
\nPostalCode
\nCountry
\n1
\nAlfreds Futterkiste
\nMaria Anders
\nObere Str. 57
\nBerlin
\n12209
\nGermany
\n2
\nAna Trujillo Emparedados y helados
\nAna Trujillo
\nAvda. de la Constituci\u00f3n 2222
\nM\u00e9xico D.F.
\n05021
\nMexico
\n3
\nAntonio Moreno Taquer\u00eda
\nAntonio Moreno
\nMataderos 2312
\nM\u00e9xico D.F.
\n05023
\nMexico<\/p>\n

\u098f\u09ac\u0982 \u098f\u0987 \u0985\u0982\u09b6\u099f\u09bf “Orders” \u099f\u09c7\u09ac\u09b2 \u09a5\u09c7\u0995\u09c7 \u09a8\u09c7\u09df\u09be \u09b9\u09df\u09c7\u099b\u09c7\u0983<\/p>\n

OrderID
\nCustomerID
\nEmployeeID
\nOrderDate
\nShipperID
\n10308
\n2
\n7
\n1996-09-18
\n3
\n10309
\n37
\n3
\n1996-09-19
\n1
\n10310
\n77
\n8
\n1996-09-20
\n2<\/p>\n

\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 FULL OUTER JOIN \u098f\u09b0 \u0989\u09a6\u09be\u09b9\u09b0\u09a3
\n\u09a8\u09bf\u099a\u09c7\u09b0 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f\u099f\u09bf \u09b8\u09ac \u0995\u09be\u09b8\u09cd\u099f\u09ae\u09be\u09b0 \u098f\u09ac\u0982 \u09b8\u09ac\u0997\u09c1\u09b2\u09cb \u0985\u09b0\u09cd\u09a1\u09be\u09b0\u0995\u09c7 \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8 \u0995\u09b0\u09c7\u0983
\nSELECT Customers.CustomerName, Orders.OrderID
\nFROM Customers
\nFULL OUTER JOIN Orders
\nON Customers.CustomerID=Orders.CustomerID
\nORDER BY Customers.CustomerName;<\/p>\n

\u098f\u0987 \u099c\u09a8\u09cd\u09af \u09af\u09c7 \u09ab\u09b2\u09be\u09ab\u09b2 \u09a4\u09c8\u09b0\u09bf \u09b9\u09df \u09a4\u09be\u09b0 \u098f\u0995\u099f\u09bf \u09ac\u09be\u099b\u09be\u0987\u0995\u09b0\u09be \u0985\u0982\u09b6\u099f\u09bf \u09a0\u09bf\u0995 \u098f\u09b0\u0995\u09ae \u09a6\u09c7\u0996\u09be\u09ac\u09c7\u0983<\/p>\n

CustomerName
\nOrderID
\nAlfreds Futterkiste<\/p>\n

Ana Trujillo Emparedados y helados
\n10308
\nAntonio Moreno Taquer\u00eda
\n10365<\/p>\n

10382<\/p>\n

10351<\/p>\n

\u09b2\u0995\u09cd\u09b7\u09cd\u09af\u09a8\u09c0\u09df\u0983 FULL OUTER JOIN \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09ac\u09be\u09ae \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2(Customers) \u098f\u09ac\u0982 \u09a1\u09be\u09a8 \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0(Orders) \u09b8\u09ac\u0997\u09c1\u09b2\u09cb \u09b8\u09be\u09b0\u09bf\u0995\u09c7 \u09ab\u09c7\u09b0\u09a4 \u09a6\u09bf\u09df\u09c7\u099b\u09c7\u0964 \u09af\u09a6\u09bf “Customers” \u099f\u09c7\u09ac\u09b2\u09c7 \u098f\u09ae\u09a8 \u0995\u09bf\u099b\u09c1 \u09b8\u09be\u09b0\u09bf \u09a5\u09be\u0995\u09c7 \u09af\u09be “Orders” \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09b8\u09be\u09a5\u09c7 \u09ae\u09bf\u09b2\u09c7\u09a8\u09be \u0985\u09a5\u09ac\u09be “Orders\u201d \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09b8\u09be\u09b0\u09bf\u0997\u09c1\u09b2\u09cb\u09b0 \u0995\u09cb\u09a8\u099f\u09bf \u09af\u09a6\u09bf “Customers” \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09b8\u09be\u09a5\u09c7 \u09a8\u09be \u09ae\u09bf\u09b2\u09c7 \u09a4\u09be\u09b9\u09b2\u09c7 \u0990 \u09b0\u09cb \u09ac\u09be \u09b8\u09be\u09b0\u09bf\u0997\u09c1\u09b2\u09cb\u0993 \u09b2\u09bf\u09b8\u09cd\u099f\u09c7 \u099a\u09b2\u09c7 \u0986\u09b8\u09ac\u09c7\u0964<\/p>\n","protected":false},"excerpt":{"rendered":"

\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09c1\u09b2 \u0986\u0989\u099f\u09be\u09b0 \u099c\u09df\u09c7\u09a8 \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 Sheikh Mahfuzur Rahman FULL OUTER JOIN \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09ac\u09be\u09ae \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2(table1) \u098f\u09ac\u0982 \u09a1\u09be\u09a8 \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0(table2) \u09b8\u09ac\u0997\u09c1\u09b2\u09cb \u09b8\u09be\u09b0\u09bf\u0995\u09c7 \u09ab\u09c7\u09b0\u09a4 \u09a6\u09c7\u09df\u0964 FULL OUTER JOIN \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 LEFT \u0993 RIGHT \u0989\u09ad\u09df \u09b8\u0982\u09af\u09cb\u0997-\u09b8\u09cd\u09a5\u09b2\u0995\u09c7\u0987 \u09ae\u09bf\u09b2\u09bf\u09df\u09c7 \u09a6\u09c7\u09df\u0964 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 FULL OUTER JOIN \u09b8\u09bf\u09a8\u09cd\u099f\u09c7\u0995\u09cd\u09b8\u099f\u0983 SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name=table2.column_name; \u09a8\u09ae\u09c1\u09a8\u09be \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f\u0987 \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2\u09c7 \u0986\u09ae\u09b0\u09be \u09b8\u09c1\u09aa\u09b0\u09bf\u099a\u09bf\u09a4 … <\/p>\n

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-5910","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":5890,"url":"http:\/\/bangla.sitestree.com\/?p=5890","url_meta":{"origin":5910,"position":0},"title":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09bf\u09b2\u09c7\u099f \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f . SQL Delete Statement","author":"Author-Check- Article-or-Video","date":"January 31, 2015","format":false,"excerpt":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09bf\u09b2\u09c7\u099f \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f Name: Sheikh Mahfuzur Rahman \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae\u09bf\u0982 \u09b2\u09c7\u0982\u0997\u09c1\u09df\u09c7\u099c\u09c7 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09b0\u09c7\u0995\u09b0\u09cd\u09a1 \u09b8\u09ae\u09c2\u09b9 \u09af\u09c7\u09ae\u09a8 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09b0\u09cb \u09ac\u09be \u09b8\u09be\u09b0\u09bf \u09ae\u09c1\u0981\u099b\u09c7 \u09ab\u09c7\u09b2\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09a1\u09bf\u09b2\u09c7\u099f(DELETE) \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u09a8\u09bf\u099a\u09c7 \u098f \u09b8\u09ae\u09cd\u09aa\u09b0\u09cd\u0995\u09c7 \u09ac\u09bf\u09b8\u09cd\u09a4\u09be\u09b0\u09bf\u09a4 \u0986\u09b2\u09cb\u099a\u09a8\u09be \u0995\u09b0\u09be \u09b9\u09b2\u09cb\u0983 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09bf\u09b2\u09c7\u099f \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09a1\u09bf\u09b2\u09c7\u099f \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09b0\u09cb \u09ac\u09be \u09b8\u09be\u09b0\u09bf\u0997\u09c1\u09b2\u09cb \u09ae\u09c1\u0981\u099b\u09c7 \u09ab\u09c7\u09b2\u09be\u09b0 \u0995\u09be\u099c\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df\u0964\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","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":5878,"url":"http:\/\/bangla.sitestree.com\/?p=5878","url_meta":{"origin":5910,"position":1},"title":"SQL SELECT Statement (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ac\u09bf\u09ac\u09c3\u09a4\u09bf \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8):","author":"Author-Check- Article-or-Video","date":"January 31, 2015","format":false,"excerpt":"SQL SELECT Statement (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ac\u09bf\u09ac\u09c3\u09a4\u09bf \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8): Article By Fazle Rabbi B.Sc in CSE at PSTU SELECT \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a5\u09c7\u0995\u09c7 \u09a4\u09a5\u09cd\u09af \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8 \u0995\u09b0\u09a4\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09af\u09bc\u0964 The SQL SELECT Statement: SELECT \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a5\u09c7\u0995\u09c7 \u09a4\u09a5\u09cd\u09af \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8 \u0995\u09b0\u09a4\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09af\u09bc\u0964 \u098f\u09b0 \u09ab\u09b2 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u09b8\u0982\u09b0\u0995\u09cd\u09b7\u09bf\u09a4 \u09b9\u09af\u09bc, \u09af\u09be\u0995\u09c7 \u09b0\u09c7\u099c\u09be\u09b2\u09cd\u099f \u09b8\u09c7\u099f\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","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":5882,"url":"http:\/\/bangla.sitestree.com\/?p=5882","url_meta":{"origin":5910,"position":2},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) WHERE \u0995\u09cd\u09b2\u099c . SQL WHERE Clause","author":"Author-Check- Article-or-Video","date":"January 31, 2015","format":false,"excerpt":"

SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) WHERE \u0995\u09cd\u09b2\u099c<\/h1> Article By: Pratap Chandra

\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a5\u09c7\u0995\u09c7 \u09a1\u09be\u099f\u09be \u09ab\u09bf\u09b2\u09cd\u099f\u09be\u09b0 (filter) \u09ac\u09be \u09aa\u09b0\u09bf\u09b6\u09cb\u09a7\u09a8 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af WHERE \u0995\u09cd\u09b2\u099c \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u098f\u0996\u09be\u09a8\u09c7 \u09aa\u09b0\u09bf\u09b6\u09cb\u09a7\u09a8 \u0995\u09b0\u09be \u09ac\u09b2\u09a4\u09c7 \u09ac\u09c1\u099d\u09be\u09a8\u09cb \u09b9\u09df\u09c7\u099b\u09c7 \u09b6\u09b0\u09cd\u09a4 \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09c7 \u0995\u09c7\u09ac\u09b2 \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8\u09c0\u09df \u09a1\u09be\u099f\u09be\u0997\u09c1\u09b2\u09cb \u09a4\u09c1\u09b2\u09c7 \u0986\u09a8\u09be\u0964 \u0986\u09aa\u09a8\u09bf \u09af\u09c7 \u09b6\u09b0\u09cd\u09a4 \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09ac\u09c7\u09a8 \u09b6\u09c1\u09a7\u09c1 \u09b8\u09c7\u0987 \u09b6\u09b0\u09cd\u09a4 \u09aa\u09c2\u09b0\u09a3 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09be \u09a1\u09be\u099f\u09be\u0987 \u0995\u09c7\u09ac\u09b2 \u09ac\u09be\u099b\u09be\u0987\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","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":5813,"url":"http:\/\/bangla.sitestree.com\/?p=5813","url_meta":{"origin":5910,"position":3},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Syntax : SQL Syntax","author":"Author-Check- Article-or-Video","date":"January 21, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Syntax Article By : Protap Chand \u0986\u099c \u0986\u09ae\u09b0\u09be \u09b6\u09bf\u0996\u09ac \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 (SQL) \u09b8\u09bf\u09a8\u099f\u09cd\u09af\u09be\u0995\u09cd\u09b8 \u09ac\u09be \u09ac\u09be\u0995\u09cd\u09af\u09b0\u09c0\u09a4\u09bf\u0964 \u09af\u09c7\u0995\u09cb\u09a8 \u09ad\u09be\u09b7\u09be\u09b0 \u09b6\u09ac\u09cd\u09a6\u09ad\u09be\u09a8\u09cd\u09a1\u09be\u09b0 \u09a8\u09bf\u09df\u09c7 \u09af\u09c7\u09ae\u09a8 \u098f\u0995\u099f\u09bf \u09a8\u09bf\u099c\u09b8\u09cd\u09ac \u09ac\u09be\u0995\u09cd\u09af\u09b0\u09c0\u09a4\u09bf \u0986\u099b\u09c7\u0964 \u09a4\u09c7\u09ae\u09a8 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f\u09b0 \u09b8\u09a0\u09bf\u0995\u09ad\u09be\u09ac\u09c7 \u09ab\u09b2\u09be\u09ab\u09b2 \u09aa\u09cd\u09b0\u09a6\u09be\u09a8 \u0995\u09b0\u09a4\u09c7 \u098f\u0995\u099f\u09be \u0997\u09a0\u09a8 \u09ac\u09be \u09ac\u09be\u0995\u09cd\u09af\u09b0\u09c0\u09a4\u09bf \u09ae\u09c7\u09a8\u09c7 \u099a\u09b2\u09a4\u09c7 \u09b9\u09df\u0964 \u0985\u09a8\u09cd\u09af\u09a5\u09be\u09df error \u09ac\u09be \u09ad\u09c1\u09b2 \u09b9\u09df\u09c7\u099b\u09c7 \u09ae\u09b0\u09cd\u09ae\u09c7 \u09ac\u09be\u09b0\u09cd\u09a4\u09be \u09aa\u09cd\u09b0\u09a6\u09b0\u09cd\u09b6\u09a8 \u0995\u09b0\u09ac\u09c7\u0964 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f\u0995\u099f\u09bf\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","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":5953,"url":"http:\/\/bangla.sitestree.com\/?p=5953","url_meta":{"origin":5910,"position":4},"title":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f .","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f Sheikh Mahfuzur Rahman \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 FOREIGHN KEY \u0985\u09a8\u09cd\u09af \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 PRIMARY KEY \u098f\u09b0 \u09a6\u09bf\u0995\u09c7 \u09a8\u09bf\u09b0\u09cd\u09a6\u09c7\u09b6 \u0995\u09b0\u09c7\u0964 \u098f\u0995\u099f\u09bf \u0989\u09a6\u09be\u09b9\u09b0\u09a3\u09c7\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 \"\u09ab\u09b0\u09c7\u09a8 \u0995\u09bf\" \u0995\u09c7 \u09ac\u09cd\u09af\u09be\u0996\u09cd\u09af\u09be \u0995\u09b0\u09be \u09af\u09be\u0995\u0964 \u09a8\u09bf\u099a\u09c7\u09b0 \u09a6\u09c1\u099f\u09cb \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09a6\u09bf\u0995\u09c7 \u09b2\u0995\u09cd\u09b7\u09cd\u09af \u0995\u09b0\u09c1\u09a8 \u09af\u09be\u09b0 \u098f\u0995\u099f\u09bf \u09b9\u09b2\u09cb ''Persons'' \u099f\u09c7\u09ac\u09b2 \u098f\u09ac\u0982 \u0985\u09a8\u09cd\u09af\u099f\u09bf \u09b9\u09b2\u09cb \"Orders\u201d \u099f\u09c7\u09ac\u09b2\u0983 The \"Persons\" table: P_Id LastName FirstName\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","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":5945,"url":"http:\/\/bangla.sitestree.com\/?p=5945","url_meta":{"origin":5910,"position":5},"title":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09b8 . SQL Constraints","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"Sheikh Mahfuzur Rahman Blogger @ BloggersEcho.Com Bengali Word Count: 155-159 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09b8 \u0993\u09df\u09c7\u09ac \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b2\u09cd\u09af\u09be\u0999\u09cd\u0997\u09c1\u09df\u09c7\u099c \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2(SQL) \u098f \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u0997\u09c1\u09b2\u09cb(Constraints) \u0995\u09cb\u09a8 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09a1\u09be\u099f\u09be\u0997\u09c1\u09b2\u09cb\u09b0 \u09b0\u09c1\u09b2\u09b8 \u09ac\u09be \u09a8\u09c0\u09a4\u09bf \u09a8\u09bf\u09b0\u09cd\u09a7\u09be\u09b0\u09a3\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u09b9\u09df\u0964 \u098f\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09a1\u09be\u099f\u09be \u0985\u09cd\u09af\u09be\u0995\u09b6\u09be\u09a8 \u098f\u09ac\u0982 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09c7\u09b0 \u09a8\u09c0\u09a4\u09bf\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u09b8\u09be\u0982\u0998\u09b0\u09cd\u09b7\u09bf\u0995(Violation) \u0995\u09bf\u099b\u09c1 \u0998\u099f\u09b2\u09c7 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09c7\u09b0 \u0995\u09be\u09b0\u09cd\u09af\u0995\u09be\u09b0\u09bf\u09a4\u09be \u09ac\u09be\u09a4\u09bf\u09b2 \u09b9\u09df\u09c7 \u09af\u09be\u09df\u0964 \u09af\u0996\u09a8 \u099f\u09c7\u09ac\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09b9\u09df \u09a4\u0996\u09a8 CREATE TABLE\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","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\/5910","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=5910"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5910\/revisions"}],"predecessor-version":[{"id":5911,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5910\/revisions\/5911"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5910"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}