{"id":5813,"date":"2015-01-21T20:20:27","date_gmt":"2015-01-22T01:20:27","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5813"},"modified":"2015-09-03T08:05:59","modified_gmt":"2015-09-03T12:05:59","slug":"sql-%e0%a6%8f%e0%a6%b8%e0%a6%95%e0%a6%bf%e0%a6%89%e0%a6%8f%e0%a6%b2-syntax-sql-syntax","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5813","title":{"rendered":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Syntax : SQL Syntax"},"content":{"rendered":"<h1>SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Syntax<\/h1>\n<p>Article By : Protap Chand<\/p>\n<p>\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<\/p>\n<p>\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c (database) \u09a5\u09c7\u0995\u09c7 \u09a1\u09be\u099f\u09be \u09a4\u09c1\u09b2\u09c7 \u098f\u09a8\u09c7 \u09aa\u09cd\u09b0\u09a6\u09b0\u09cd\u09b6\u09a8 \u0995\u09b0\u09c7 \u0964<\/p>\n<p>\u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u0986\u09ae\u09b0\u09be \u099c\u09be\u09a8\u09ac \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09ae\u09cd\u09aa\u09b0\u09cd\u0995\u09c7\u0964 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u0997\u09a0\u09bf\u09a4 \u09b9\u09df \u098f\u0995 \u09ac\u09be \u098f\u0995\u09be\u09a7\u09bf\u0995 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09b8\u09ae\u09a8\u09cd\u09ac\u09df\u09c7\u0964 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 \u0985\u09a7\u09c0\u09a8 \u09af\u09a4\u0997\u09c1\u09b2\u09cb \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09be\u0995\u09ac\u09c7 \u09a4\u09be\u09b0 \u09aa\u09cd\u09b0\u09a4\u09bf\u099f\u09bf\u09b0 \u098f\u0995\u099f\u09bf \u09aa\u09c3\u09a5\u0995 \u09a8\u09be\u09ae \u09a5\u09be\u0995\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u09a1\u09be\u099f\u09be \u09b8\u09ae\u09cd\u09ac\u09b2\u09bf\u09a4 \u098f\u0995 \u09ac\u09be \u098f\u0995\u09be\u09a7\u09bf\u0995 \u09b0\u09c7\u0995\u09b0\u09cd\u09a1 \u09ac\u09be \u09b8\u09be\u09b0\u09bf \u09a5\u09be\u0995\u09c7\u0964<\/p>\n<p>\u098f\u0987 \u099f\u09bf\u0989\u099f\u09bf\u09b0\u09bf\u09df\u09be\u09b2\u09c7 \u0986\u09ae\u09b0\u09be \u09ac\u09b9\u09c1\u09b2 \u09aa\u09b0\u09bf\u099a\u09bf\u09a4 Northwind \u09b8\u09cd\u09af\u09be\u09ae\u09cd\u09aa\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u099f\u09bf \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac, \u09af\u09c7\u099f\u09bf \u09ae\u09be\u0987\u0995\u09cd\u09b0\u09cb\u09b8\u09ab\u099f Excel \u098f\u09ac\u0982 MS SQL Server \u098f\u09b0 \u09b8\u09be\u09a5\u09c7 \u09b6\u09bf\u0995\u09cd\u09b7\u09be\u09b0\u09cd\u09a5\u09c0\u09a6\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u09a4\u09c8\u09b0\u09c0 \u0985\u09ac\u09b8\u09cd\u09a5\u09be\u09df (readymade) \u09b8\u0982\u09af\u09c1\u0995\u09cd\u09a4 \u0995\u09b0\u09be \u09a5\u09be\u0995\u09c7\u0964 \u09b8\u09c7\u0987 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 Customers \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u0995\u09bf\u099b\u09c1 \u09a1\u09be\u099f\u09be SELECT \u0995\u09ae\u09be\u09a8\u09cd\u09a1 \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09c7 \u09ac\u09be\u099b\u09be\u0987 \u0995\u09b0\u09be \u09b9\u09df\u09c7\u099b\u09c7, \u09af\u09be \u09a8\u09bf\u099a\u09c7\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09b2\u09cb:<\/p>\n<table border=\"1\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td>\n<p align=\"center\"><strong>CustomerID<\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>CustomerName<\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>ContactName<\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>Address<\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>City<\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>PostalCode<\/strong><\/p>\n<\/td>\n<td>\n<p align=\"center\"><strong>Country<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Alfreds Futterkiste<\/td>\n<td>Maria Anders<\/td>\n<td>Obere Str. 57<\/td>\n<td>Berlin<\/td>\n<td>12209<\/td>\n<td>Germany<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Ana Trujillo Emparedados y helados<\/td>\n<td>Ana Trujillo<\/td>\n<td>Avda. de la Constituci\u00f3n 2222<\/td>\n<td>M\u00e9xico D.F.<\/td>\n<td>05021<\/td>\n<td>Mexico<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Antonio Moreno Taquer\u00eda<\/td>\n<td>Antonio Moreno<\/td>\n<td>Mataderos 2312<\/td>\n<td>M\u00e9xico D.F.<\/td>\n<td>05023<\/td>\n<td>Mexico<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Around the Horn<\/td>\n<td>Thomas Hardy<\/td>\n<td>120 Hanover Sq.<\/td>\n<td>London<\/td>\n<td>WA1 1DP<\/td>\n<td>UK<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Berglunds snabbk\u00f6p<\/td>\n<td>Christina Berglund<\/td>\n<td>Berguvsv\u00e4gen 8<\/td>\n<td>Lule\u00e5<\/td>\n<td>S-958 22<\/td>\n<td>Sweden<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u0989\u09aa\u09b0\u09c7\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u09aa\u09be\u099a\u099f\u09bf \u09b0\u09c7\u0995\u09b0\u09cd\u09a1 (\u09aa\u09cd\u09b0\u09a4\u09bf \u0995\u09be\u09b8\u09cd\u099f\u09ae\u09be\u09b0 \u098f\u09b0 \u099c\u09a8\u09cd\u09af \u098f\u0995\u099f\u09bf \u0995\u09b0\u09c7) \u098f\u09ac\u0982 \u09b8\u09be\u09a4\u099f\u09bf \u0995\u09b2\u09be\u09ae \u09a6\u09c7\u0996\u09be \u09af\u09be\u099a\u09cd\u099b\u09c7\u0964 \u0995\u09b2\u09be\u09ae\u0997\u09c1\u09b2\u09cb\u09b0 \u09a8\u09be\u09ae \u09b9\u099a\u09cd\u099b\u09c7 CustomerID, CustomerName, ContactName, Address, City, PostalCode \u098f\u09ac\u0982 Country.<\/p>\n<h3>SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f (Statements)<\/h3>\n<p>\u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a5\u09c7\u0995\u09c7 \u09a1\u09be\u099f\u09be \u09ac\u09be \u09a4\u09a5\u09cd\u09af \u09a4\u09c1\u09b2\u09c7 \u0986\u09a8\u09be \u09b9\u09df SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7\u0964 \u09a8\u09bf\u099a\u09c7\u09b0 SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f\u099f\u09bf \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09b2\u09c7 Northwind \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 Customers \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09b8\u09ac \u09a1\u09be\u099f\u09be \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8 \u09b9\u09ac\u09c7\u0964<\/p>\n<p>SELECT * FROM Customers;<\/p>\n<p>\u098f\u0996\u09be\u09a8\u09c7 \u0989\u09b2\u09cd\u09b2\u09c7\u0996 \u0995\u09b0\u09be \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8 \u09af\u09c7 SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f case sensitive \u09a8\u09df\u0964 \u0985\u09b0\u09cd\u09a5\u09be\u09a4 \u099b\u09cb\u099f \u09b9\u09be\u09a4\u09c7\u09b0 (lower case) \u0995\u09bf\u0982\u09ac\u09be \u09ac\u09dc \u09b9\u09be\u09a4\u09c7\u09b0 (upper case) \u0985\u0995\u09cd\u09b7\u09b0\u09c7 \u09b2\u09c7\u0996\u09be \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u098f\u0995\u0987 \u09ab\u09b2 \u09a6\u09c7\u09ac\u09c7\u0964 \u09a4\u09ac\u09c7 \u098f\u0987 \u099f\u09bf\u0989\u099f\u09b0\u09bf\u09df\u09be\u09b2\u09c7 \u0986\u09ae\u09b0\u09be \u09ac\u09dc \u09b9\u09be\u09a4\u09c7\u09b0 \u0985\u0995\u09cd\u09b7\u09b0\u09c7 \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09b2\u09bf\u0996\u09ac\u0964<\/p>\n<h3>\u09b8\u09c7\u09ae\u09bf\u0995\u09cb\u09b2\u09a8 \u09aa\u09cd\u09b0\u09b8\u0999\u09cd\u0997:<\/h3>\n<p>\u0995\u09bf\u099b\u09c1 \u0995\u09bf\u099b\u09c1 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae\u09c7 \u0995\u09ae\u09be\u09a8\u09cd\u09a1 \u0995\u09be\u09b0\u09cd\u09af\u0995\u09b0 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09aa\u09cd\u09b0\u09a4\u09bf\u099f\u09bf SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u098f\u09b0 \u09aa\u09b0 \u09b8\u09c7\u09ae\u09bf\u0995\u09cb\u09b2\u09a8 (;) \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8 \u09b9\u09df\u0964 \u09af\u09c7\u09b8\u09ac \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae\u09c7 \u098f\u0995 \u0995\u09b2\u09c7 \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 \u098f\u0995\u09be\u09a7\u09bf\u0995 \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u0995\u09be\u09b0\u09cd\u09af\u0995\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df \u09b8\u09c7\u0987 \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae\u09c7 \u098f\u0995\u09be\u09a7\u09bf\u0995 SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u0995\u09c7 \u098f\u0995\u099f\u09bf\u09b0 \u09b8\u0999\u09cd\u0997\u09c7 \u0985\u09a8\u09cd\u09af\u099f\u09bf\u0995\u09c7 \u0986\u09b2\u09be\u09a6\u09be \u0995\u09b0\u09a4\u09c7 \u09b8\u09c7\u09ae\u09bf\u0995\u09cb\u09b2\u09a8 \u09b9\u099a\u09cd\u099b\u09c7 \u0986\u09a6\u09b0\u09cd\u09b6 \u0989\u09aa\u09be\u09df\u0964 \u098f\u0987 \u099f\u09bf\u0989\u099f\u09b0\u09bf\u09df\u09be\u09b2\u09c7 \u0986\u09ae\u09b0\u09be \u09aa\u09cd\u09b0\u09a4\u09bf\u099f\u09bf SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u098f\u09b0 \u09aa\u09b0 \u09b8\u09c7\u09ae\u09bf\u0995\u09cb\u09b2\u09a8 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac\u0964<\/p>\n<h3>\u09b8\u09ac\u099a\u09c7 \u09ac\u09c7\u09b6\u09bf \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u098f\u09ac\u0982 \u0997\u09c1\u09b0\u09c1\u09a4\u09cd\u09ac\u09aa\u09c2\u09b0\u09cd\u09a3 \u0995\u09bf\u099b\u09c1 SQL \u0995\u09ae\u09be\u09a8\u09cd\u09a1 \u09a8\u09bf\u099a\u09c7 \u09a6\u09c7\u09df\u09be \u09b9\u09b2\u09cb:<\/h3>\n<ul type=\"disc\">\n<li><strong>SELECT<\/strong> &#8211; \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a5\u09c7\u0995\u09c7 \u09a1\u09be\u099f\u09be \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8 \u0995\u09b0\u09c7<\/li>\n<li><strong>UPDATE<\/strong> \u2013 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7 \u09a1\u09be\u099f\u09be update \u09ac\u09be \u09b9\u09be\u09b2\u09a8\u09be\u0997\u09be\u09a6 \u0995\u09b0\u09c7<\/li>\n<li><strong>DELETE<\/strong> \u2013 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a5\u09c7\u0995\u09c7 \u09a1\u09be\u099f\u09be \u09ae\u09c1\u099b\u09c7 \u09ab\u09c7\u09b2\u09c7<\/li>\n<li><strong>INSERT INTO<\/strong> \u2013 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7 \u09a8\u09a4\u09c1\u09a8 \u09a1\u09be\u099f\u09be \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6 \u0995\u09b0\u09be\u09df<\/li>\n<li><strong>CREATE DATABASE<\/strong> \u2013 \u09a8\u09a4\u09c1\u09a8 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09c0 \u0995\u09b0\u09c7<\/li>\n<li><strong>ALTER DATABASE<\/strong> \u2013 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7 \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09a8 \u0986\u09a8\u09be\u09b0 \u0995\u09be\u099c \u0995\u09b0\u09c7<\/li>\n<li><strong>CREATE TABLE<\/strong> \u2013 \u09a8\u09a4\u09c1\u09a8 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09c0 \u0995\u09b0\u09c7<\/li>\n<li><strong>ALTER TABLE<\/strong> \u2013 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09a8 \u0986\u09a8\u09be\u09b0 \u0995\u09be\u099c \u0995\u09b0\u09c7<\/li>\n<li><strong>DROP TABLE<\/strong> \u2013 \u09a8\u09be\u09ae \u0989\u09b2\u09cd\u09b2\u09c7\u0996 \u0995\u09b0\u09be \u099f\u09c7\u09ac\u09bf\u09b2\u099f\u09bf \u09ae\u09c1\u099b\u09c7 \u09ab\u09c7\u09b2\u09c7<\/li>\n<li><strong>CREATE INDEX<\/strong> \u2013 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8 \u09ac\u09be \u09b8\u09be\u09b0\u09cd\u099a \u0995\u09c0 \u09a4\u09c8\u09b0\u09c0 \u0995\u09b0\u09c7<\/li>\n<li><strong>DROP INDEX<\/strong> \u2013 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8 \u09ae\u09c1\u099b\u09c7 \u09ab\u09c7\u09b2\u09c7<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c (database) \u09a5\u09c7\u0995\u09c7 \u09a1\u09be\u099f\u09be \u09a4\u09c1\u09b2\u09c7 &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=5813\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[155],"tags":[],"class_list":["post-5813","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":5959,"url":"http:\/\/bangla.sitestree.com\/?p=5959","url_meta":{"origin":5813,"position":0},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) CREATE INDEX \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) CREATE INDEX \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f Article By : Protap Chandra \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8 \u09b6\u09ac\u09cd\u09a6\u09c7\u09b0 \u0985\u09b0\u09cd\u09a5 \u09b9\u09b2\u09cb \u09b8\u09c2\u099a\u09bf\u0995\u09b0\u09a3\u0964 \u09b8\u09b9\u099c\u09c7 \u0993 \u0995\u09ae \u09b8\u09ae\u09df\u09c7 \u09a1\u09be\u099f\u09be \u0996\u09c1\u0981\u099c\u09c7 \u09ac\u09c7\u09b0 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09a1\u09be\u099f\u09be\u0995\u09c7 \u098f\u0995\u099f\u09bf \u09ac\u09bf\u09b6\u09c7\u09b7 \u0985\u09b0\u09cd\u09a1\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09bf\u09df\u09c7 \u09b0\u09be\u0996\u09be\u0995\u09c7 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8\u09bf\u0982 \u09ac\u09b2\u09c7\u0964 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09a1\u09be\u099f\u09be\u0995\u09c7 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8\u09bf\u0982 \u0995\u09b0\u09a4\u09c7 CREATE INDEX \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8 \u0995\u09b0\u09be \u09a5\u09be\u0995\u09b2\u09c7 \u0996\u09c1\u09ac \u09b8\u09b9\u099c\u09c7 \u09a1\u09be\u099f\u09be \u0996\u09c1\u0981\u099c\u09c7 \u09ac\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":6031,"url":"http:\/\/bangla.sitestree.com\/?p=6031","url_meta":{"origin":5813,"position":1},"title":"SQL(\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Wildcards (\u0993\u09df\u09be\u0987\u09b2\u09cd\u09a1\u0995\u09be\u09b0\u09cd\u09a1) . SQL Wildcards","author":"Author-Check- Article-or-Video","date":"February 4, 2015","format":false,"excerpt":"SQL(\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Wildcards (\u0993\u09df\u09be\u0987\u09b2\u09cd\u09a1\u0995\u09be\u09b0\u09cd\u09a1) Author: Protap Chandra | sincerely.yours2512[at]gmail.com \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae\u09c7 \u09a1\u09be\u099f\u09be \u09a4\u09b2\u09cd\u09b2\u09be\u09b6\u09bf \u09ac\u09be \u09b8\u09be\u09b0\u09cd\u099a \u0995\u09b0\u09be\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 wildcard (\u0993\u09df\u09be\u0987\u09b2\u09cd\u09a1\u0995\u09be\u09b0\u09cd\u09a1) \u098f\u0995\u099f\u09bf \u0997\u09c1\u09b0\u09c1\u09a4\u09cd\u09ac\u09aa\u09c2\u09b0\u09cd\u09a3 \u099f\u09be\u09b0\u09cd\u09ae\u0964 \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982 \u09a1\u09be\u099f\u09be\u09b0 \u0995\u09cb\u09a8\u09cb \u0985\u0982\u09b6 \u200c\u200c'\u0985\u099c\u09cd\u099e\u09be\u09a4' \u0989\u09b2\u09cd\u09b2\u09c7\u0996 \u0995\u09b0\u09c7 \u09a1\u09be\u099f\u09be \u09a4\u09b2\u09cd\u09b2\u09be\u09b6\u09bf \u0995\u09b0\u09a4\u09c7 \u0993\u09df\u09be\u0987\u09b2\u09cd\u09a1\u0995\u09be\u09b0\u09cd\u09a1 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u098f\u0987 \u0985\u099c\u09cd\u099e\u09be\u09a4 \u0985\u0982\u09b6 \u098f\u0995 \u09a5\u09c7\u0995\u09c7 \u09ac\u09b9\u09c1 character (\u0985\u0995\u09cd\u09b7\u09b0) \u09aa\u09b0\u09cd\u09af\u09a8\u09cd\u09a4 \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u0964 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09ad\u09c7\u09a4\u09b0 \u09a5\u09c7\u0995\u09c7\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":5813,"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":5899,"url":"http:\/\/bangla.sitestree.com\/?p=5899","url_meta":{"origin":5813,"position":3},"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":5813,"position":4},"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":[]},{"id":5892,"url":"http:\/\/bangla.sitestree.com\/?p=5892","url_meta":{"origin":5813,"position":5},"title":"SQL LIKE (\u09b2\u09be\u0987\u0995) Operator (\u0985\u09aa\u09be\u09b0\u09c7\u099f\u09b0) . SQL Like Operator","author":"Author-Check- Article-or-Video","date":"January 31, 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\/5813","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=5813"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5813\/revisions"}],"predecessor-version":[{"id":5814,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5813\/revisions\/5814"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5813"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}