{"id":5969,"date":"2015-01-30T23:59:33","date_gmt":"2015-01-31T04:59:33","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5969"},"modified":"2015-09-03T08:13:14","modified_gmt":"2015-09-03T12:13:14","slug":"sql-%e0%a6%8f%e0%a6%b8%e0%a6%95%e0%a6%bf%e0%a6%89%e0%a6%8f%e0%a6%b2-null-values%e0%a6%ae%e0%a6%be%e0%a6%a8-sql-null-values","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5969","title":{"rendered":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) NULL Values(\u09ae\u09be\u09a8): SQL Null Values"},"content":{"rendered":"<p>SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) NULL Values(\u09ae\u09be\u09a8):<br \/>\nNull value \u09ac\u09b2\u09a4\u09c7 \u0985\u09a8\u09c1\u09aa\u09b8\u09cd\u09a5\u09bf\u09a4 \u09ac\u09be \u09ae\u09be\u09a8\u09b9\u09c0\u09a8 data \u09ac\u09c1\u099d\u09be\u09df \u0964 \u098f\u09b0 \u09ae\u09be\u09a8 \u0995\u0996\u09a8 \u09b6\u09c1\u09a8\u09cd\u09af \u09ac\u09be \u0996\u09be\u09b2\u09bf \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982<br \/>\n(String) \u09b9\u09df \u09a8\u09be \u098f\u09ac\u0982 \u098f\u0987 \u09b6\u09c1\u09a8\u09cd\u09af \u09ac\u09be \u0996\u09be\u09b2\u09bf \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982(String) \u098f\u0995\u099f\u09bf \u09ae\u09be\u09a8 \u09aa\u09cd\u09b0\u0995\u09be\u09b6 \u0995\u09b0\u09c7 \u0995\u09bf\u09a8\u09cd\u09a4\u09c1 \u0986\u09ae\u09b0\u09be \u099c\u09be\u09a8\u09bf NULL \u098f\u09b0 \u0995\u09cb\u09a8 \u09ae\u09be\u09a8 \u09a8\u09c7\u0987 \u0964 NULL \u098f\u09b0 \u09ae\u09be\u09a8 NULL \u098f \u0997\u09a0\u09bf\u09a4 \u0997\u09be\u09a3\u09bf\u09a4\u09bf\u0995 \u09ab\u09b2\u09be\u09ab\u09b2 \u09a6\u09cd\u09ac\u09be\u09b0\u09be \u09a8\u09bf\u09b0\u09cd\u09a3\u09df \u0995\u09b0\u09be \u09b9\u09df \u0964 \u09af\u09c7\u09ae\u09a8\u0983 10 + NULL = NULL<\/p>\n<p>\u09aa\u09a6\u09ac\u09bf\u09a8\u09cd\u09af\u09be\u09b8 (Syntax):<\/p>\n<p>SQL&gt; CREATE TABLE CUSTOMERS(<br \/>\nID INT NOT NULL,<br \/>\nNAME VARCHAR (20) NOT NULL,<br \/>\nAGE INT NOT NULL,<br \/>\nADDRESS CHAR (25) ,<br \/>\nSALARY DECIMAL (18, 2),<br \/>\nPRIMARY KEY (ID)<br \/>\n);<\/p>\n<p>\u098f\u0996\u09be\u09a8\u09c7 NOT NULL \u09ae\u09be\u09a8\u09c7 \u0995\u09b2\u09be\u09ae \u09b8\u09ac\u09b8\u09ae\u09af\u09bc \u098f\u0995\u099f\u09bf \u09b8\u09c1\u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u09ae\u09be\u09a8 \u0997\u09cd\u09b0\u09b9\u09a3 \u0995\u09b0\u09c7 \u09af\u09be\u09b0 \u09ae\u09be\u09a8 \u09a6\u09c7\u09df\u09be \u09a5\u09be\u0995\u09c7 \u0964 \u098f\u0996\u09be\u09a8\u09c7 \u09a6\u09c1\u099f\u09bf \u0995\u09b2\u09be\u09ae \u0986\u099b\u09c7 \u09af\u09c7\u0996\u09be\u09a8\u09c7 \u0986\u09ae\u09b0\u09be NOT NULL \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09bf \u09a8\u09be\u0987 \u09af\u09be\u09b0 \u09ae\u09be\u09a8\u09c7 \u098f\u0987 \u0995\u09b2\u09be\u09ae\u0997\u09c1\u09b2\u09cb NULL \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7 \u0964<br \/>\nNULL value \u098f\u09ae\u09a8 \u098f\u0995\u099f\u09bf \u09ae\u09be\u09a8 \u09af\u09be \u0995\u09cb\u09a8 \u09b0\u09c7\u0995\u09b0\u09cd\u09a1 \u09a8\u09bf\u09b0\u09cd\u09ae\u09be\u09a3\u09c7\u09b0 \u09b8\u09ae\u09af\u09bc \u0996\u09be\u09b2\u09bf \u09b0\u09be\u0996\u09be \u09b9\u09df \u0964<\/p>\n<p>\u09af\u09c7\u09ae\u09a8\u0983<br \/>\n\u0986\u09aa\u09a8\u09be\u0995\u09c7 \u0985\u09ac\u09b6\u09cd\u09af\u0987 NULL value \u099a\u09c7\u0995 \u0995\u09b0\u09be\u09b0 \u09b8\u09ae\u09df \u09b9\u09df IS NULL \u0985\u09a5\u09ac\u09be IS NOT NULL \u0985\u09aa\u09be\u09b0\u09c7\u099f\u09b0<br \/>\n\u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u0964 \u09a8\u09bf\u099a\u09c7\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 CUSTOMERS-\u098f\u09b0 \u09a8\u09bf\u09ae\u09cd\u09a8\u09b2\u09bf\u0996\u09bf\u09a4 \u09ac\u09bf\u09ac\u09b0\u09a3 \u09b0\u09df\u09c7\u099b\u09c7\u0983<\/p>\n<p>+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<br \/>\n| ID | NAME | AGE | ADDRESS | SALARY |<br \/>\n+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<br \/>\n| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |<br \/>\n| 2 | Khilan | 25 | Delhi | 1500.00 |<br \/>\n| 3 | kaushik | 23 | Kota | 2000.00 |<br \/>\n| 4 | Chaitali | 25 | Mumbai | 6500.00 |<br \/>\n| 5 | Hardik | 27 | Bhopal | 8500.00 |<br \/>\n| 6 | Komal | 22 | MP | |<br \/>\n| 7 | Muffy | 24 | Indore | |<br \/>\n+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<\/p>\n<p>\u09a8\u09bf\u09ae\u09cd\u09a8\u09b2\u09bf\u0996\u09bf\u09a4 \u0989\u09a6\u09be\u09b9\u09b0\u09a3\u099f\u09bf IS NOT NULL \u0985\u09aa\u09be\u09b0\u09c7\u099f\u09b0:<\/p>\n<p>SQL&gt; SELECT ID, NAME, AGE, ADDRESS, SALARY<br \/>\nFROM CUSTOMERS<br \/>\nWHERE SALARY IS NOT NULL;<\/p>\n<p>\u09af\u09be \u09a8\u09bf\u09ae\u09cd\u09a8\u09b2\u09bf\u0996\u09bf\u09a4 \u09ab\u09b2\u09be\u09ab\u09b2 \u09aa\u09cd\u09b0\u0995\u09be\u09b6 \u0995\u09b0\u09c7\u0983<\/p>\n<p>+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<br \/>\n| ID | NAME | AGE | ADDRESS | SALARY |<br \/>\n+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<br \/>\n| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |<br \/>\n| 2 | Khilan | 25 | Delhi | 1500.00 |<br \/>\n| 3 | kaushik | 23 | Kota | 2000.00 |<br \/>\n| 4 | Chaitali | 25 | Mumbai | 6500.00 |<br \/>\n| 5 | Hardik | 27 | Bhopal | 8500.00 |<br \/>\n+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<\/p>\n<p>\u09a8\u09bf\u09ae\u09cd\u09a8\u09b2\u09bf\u0996\u09bf\u09a4 \u0989\u09a6\u09be\u09b9\u09b0\u09a3\u099f\u09bf IS NULL \u0985\u09aa\u09be\u09b0\u09c7\u099f\u09b0:<\/p>\n<p>SQL&gt; SELECT ID, NAME, AGE, ADDRESS, SALARY<br \/>\nFROM CUSTOMERS<br \/>\nWHERE SALARY IS NULL;<\/p>\n<p>\u09af\u09be \u09a8\u09bf\u09ae\u09cd\u09a8\u09b2\u09bf\u0996\u09bf\u09a4 \u09ab\u09b2\u09be\u09ab\u09b2 \u09aa\u09cd\u09b0\u0995\u09be\u09b6 \u0995\u09b0\u09c7\u0983<\/p>\n<p>+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<br \/>\n| ID | NAME | AGE | ADDRESS | SALARY |<br \/>\n+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<br \/>\n| 6 | Komal | 22 | MP | |<br \/>\n| 7 | Muffy | 24 | Indore | |<br \/>\n+&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8211;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;-+<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) NULL Values(\u09ae\u09be\u09a8): Null value \u09ac\u09b2\u09a4\u09c7 \u0985\u09a8\u09c1\u09aa\u09b8\u09cd\u09a5\u09bf\u09a4 \u09ac\u09be \u09ae\u09be\u09a8\u09b9\u09c0\u09a8 data \u09ac\u09c1\u099d\u09be\u09df \u0964 \u098f\u09b0 \u09ae\u09be\u09a8 \u0995\u0996\u09a8 \u09b6\u09c1\u09a8\u09cd\u09af \u09ac\u09be \u0996\u09be\u09b2\u09bf \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982 (String) \u09b9\u09df \u09a8\u09be \u098f\u09ac\u0982 \u098f\u0987 \u09b6\u09c1\u09a8\u09cd\u09af \u09ac\u09be \u0996\u09be\u09b2\u09bf \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982(String) \u098f\u0995\u099f\u09bf \u09ae\u09be\u09a8 \u09aa\u09cd\u09b0\u0995\u09be\u09b6 \u0995\u09b0\u09c7 \u0995\u09bf\u09a8\u09cd\u09a4\u09c1 \u0986\u09ae\u09b0\u09be \u099c\u09be\u09a8\u09bf NULL \u098f\u09b0 \u0995\u09cb\u09a8 \u09ae\u09be\u09a8 \u09a8\u09c7\u0987 \u0964 NULL \u098f\u09b0 \u09ae\u09be\u09a8 NULL \u098f \u0997\u09a0\u09bf\u09a4 \u0997\u09be\u09a3\u09bf\u09a4\u09bf\u0995 \u09ab\u09b2\u09be\u09ab\u09b2 \u09a6\u09cd\u09ac\u09be\u09b0\u09be \u09a8\u09bf\u09b0\u09cd\u09a3\u09df \u0995\u09b0\u09be \u09b9\u09df \u0964 &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=5969\">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-5969","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":6087,"url":"http:\/\/bangla.sitestree.com\/?p=6087","url_meta":{"origin":5969,"position":0},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf : \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf (PHP Create MySQL Tables)","author":"Author-Check- Article-or-Video","date":"February 23, 2015","format":false,"excerpt":"\u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09a8\u09bf\u099c\u09b8\u09cd\u09ac \u09a8\u09be\u09ae \u09a5\u09be\u0995\u09c7 \u098f\u09ac\u0982 \u098f\u099f\u09be \u0995\u09b2\u09be\u09ae \u0993 \u09b8\u09be\u09b0\u09bf \u09a8\u09bf\u09af\u09bc\u09c7 \u0997\u09a0\u09bf\u09a4 \u09b9\u09df\u0964 MySQLi \u098f\u09ac\u0982 PDO \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099b\u0995 (table) \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 CREATE TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u0986\u09ae\u09b0\u09be \u098f\u0996\u09a8 \"MyGuests\" \u09a8\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09ac\u09cb \u09af\u09be\u09b0 \"id\", \"firstname\", \"lastname\", \"email\"\u2026","rel":"","context":"In &quot;\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial&quot;","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11166,"url":"http:\/\/bangla.sitestree.com\/?p=11166","url_meta":{"origin":5969,"position":1},"title":"C \u098f\u09b0 \u09b8\u09be\u09a5\u09c7 Python \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae\u09bf\u0982 \u098f\u0995\u09cd\u09b8\u099f\u09c7\u09a8\u09b6\u09a8 (Python Extension Programming with C)","author":"","date":"October 31, 2015","format":false,"excerpt":"C \u098f\u09b0 \u09b8\u09be\u09a5\u09c7 Python \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae\u09bf\u0982 \u098f\u0995\u09cd\u09b8\u099f\u09c7\u09a8\u09b6\u09a8 C, C++ \u0985\u09a5\u09ac\u09be Java \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae\u09bf\u0982 \u098f\u09b0 \u09af\u09c7\u0995\u09cb\u09a8 \u0995\u09cb\u09a1 Python script \u098f\u09b0 \u09b8\u09be\u09a5\u09c7 \u0987\u09a8\u09cd\u099f\u09c7\u0997\u09cd\u09b0\u09c7\u099f\/ \u09b0\u09c2\u09aa\u09be\u09a8\u09cd\u09a4\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df, \u09af\u09be\u0995\u09c7 Python \u098f\u0995\u09cd\u09b8\u099f\u09c7\u09a8\u09b6\u09a8 \u09ac\u09b2\u09c7\u0964 Python \u098f\u0995\u09cd\u09b8\u099f\u09c7\u09a8\u09b6\u09a8 \u09ab\u09be\u0987\u09b2\u0997\u09c1\u09b2\u09cb \u09b8\u09cd\u09ac\u09be\u09ad\u09be\u09ac\u09bf\u0995 C \u09b2\u09be\u0987\u09ac\u09cd\u09b0\u09c7\u09b0\u09c0\u09b0 \u09ae\u09a4, Unix \u0985\u09aa\u09be\u09b0\u09c7\u099f\u09bf\u0982 \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae \u098f\u00a0.so\u00a0\u09ab\u09b0\u09ae\u09cd\u09af\u09be\u099f \u0993 Windows \u09ae\u09c7\u09b6\u09bf\u09a8\u09c7.dll\u00a0\u09ab\u09b0\u09ae\u09cd\u09af\u09be\u099f\u09c7\u09b0 \u09b9\u09df\u0964 \u00a0 \u098f\u0995\u09cd\u09b8\u099f\u09c7\u09a8\u09b6\u09a8 \u09b2\u09c7\u0996\u09be\u09b0 \u09aa\u09c2\u09b0\u09cd\u09ac\u09b6\u09b0\u09cd\u09a4 Python \u098f\u0995\u09cd\u09b8\u099f\u09c7\u09a8\u09b6\u09a8 \u09b2\u09bf\u0996\u09a4\u09c7 \u09b9\u09b2\u09c7 Python\u2026","rel":"","context":"In &quot;Python&quot;","block_context":{"text":"Python","link":"http:\/\/bangla.sitestree.com\/?cat=1613"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5903,"url":"http:\/\/bangla.sitestree.com\/?p=5903","url_meta":{"origin":5969,"position":2},"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":[]},{"id":6002,"url":"http:\/\/bangla.sitestree.com\/?p=6002","url_meta":{"origin":5969,"position":3},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09eb \u09a1\u09be\u099f\u09be \u099f\u09be\u0987\u09aa (PHP 5 Data Types)","author":"Author-Check- Article-or-Video","date":"February 4, 2015","format":false,"excerpt":"\u0986\u0995\u09cd\u09a4\u09be\u09b0\u09c1\u099c\u09cd\u099c\u09be\u09ae\u09be\u09a8 Department of CSE, University of Chittagong \u09ad\u09c7\u09b0\u09bf\u09df\u09c7\u09ac\u09b2 \u09ac\u09bf\u09ad\u09a8\u09cd\u09a8 \u09b0\u0995\u09ae\u09c7\u09b0 \u09a1\u09be\u099f\u09be \u09b8\u09cd\u099f\u09cb\u09b0 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7, \u098f\u09ac\u0982 \u09ac\u09bf\u09ad\u09a8\u09cd\u09a8 \u09a1\u09be\u099f\u09be \u099f\u09be\u0987\u09aa \u09ac\u09bf\u09ad\u09a8\u09cd\u09a8 \u09b0\u0995\u09ae \u0995\u09be\u099c \u0995\u09b0\u09c7\u0964 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a8\u09bf\u099a\u09c7 \u0989\u09b2\u09cd\u09b2\u09c7\u0996\u09bf\u09a4 \u09a1\u09be\u099f\u09be \u099f\u09be\u0987\u09aa \u0997\u09c1\u09b2\u09cb \u09b8\u09be\u09aa\u09cb\u09b0\u09cd\u099f \u0995\u09b0\u09c7\u0964 \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982 (String): \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982 \u09a4\u09c8\u09b0\u09bf \u09b9\u09df \u098f\u0995 \u09ac\u09be \u098f\u0995\u09be\u09a7\u09bf\u0995 \u0995\u09cd\u09af\u09be\u09b0\u09c7\u0995\u09cd\u099f\u09be\u09b0 \u09ae\u09bf\u09b2\u09c7 \u0964 \u09b8\u09cb\u099c\u09be \u0995\u09a5\u09be\u09df \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982 \u09b9\u099a\u09cd\u099b\u09c7 \u0995\u09cd\u09af\u09be\u09b0\u09c7\u0995\u09cd\u099f\u09be\u09b0\u09c7\u09b0 \u09b8\u09ae\u09b7\u09cd\u099f\u09bf \u0964 \u09af\u09c7\u09ae\u09a8\u0983 \u201cHello\u2026","rel":"","context":"In &quot;\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial&quot;","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5899,"url":"http:\/\/bangla.sitestree.com\/?p=5899","url_meta":{"origin":5969,"position":4},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) SELECT TOP \u0995\u09cd\u09b2\u099c . SQL SELECT TOP Clause","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":[]},{"id":5901,"url":"http:\/\/bangla.sitestree.com\/?p=5901","url_meta":{"origin":5969,"position":5},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) BETWEEN \u0985\u09aa\u09be\u09b0\u09c7\u099f\u09b0: SQL BETWEEN Operator","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\/5969","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=5969"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5969\/revisions"}],"predecessor-version":[{"id":5970,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5969\/revisions\/5970"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5969"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}