{"id":5965,"date":"2015-01-30T23:59:08","date_gmt":"2015-01-31T04:59:08","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5965"},"modified":"2015-09-03T08:09:55","modified_gmt":"2015-09-03T12:09:55","slug":"sql-views","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5965","title":{"rendered":": SQL Views"},"content":{"rendered":"<p>Title: SQL Views<br \/>\n\u0985\u09a8\u09c1\u09ac\u09be\u09a6\u0995: \u09ab\u09df\u09b8\u09be\u09b2 \u09b0\u0995\u09bf (\u098f\u09ae.\u098f)<br \/>\nTotal words in the article: 478<\/p>\n<p>SQL \u098f view \u09ac\u09b2\u09a4\u09c7 virtual table \u098f\u09b0 view \u0995\u09c7 \u09ac\u09cb\u099d\u09be\u09df, \u0985\u09b0\u09cd\u09a5\u09be\u09ce real table \u0995\u09c7 virtually \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09df\u0964<br \/>\n\u0995\u09bf\u09ad\u09be\u09ac\u09c7 view create, update \u09ac\u09be delete \u0995\u09b0\u09be \u09b9\u09df \u09a4\u09be \u098f\u0987 \u0985\u09a7\u09cd\u09af\u09be\u09df\u09c7 \u0986\u09b2\u09cb\u099a\u09a8\u09be \u0995\u09b0\u09be \u09b9\u09ac\u09c7\u0964<\/p>\n<p>SQL CREATE VIEW Statement<br \/>\nSQL statement \u098f\u09b0 result-set \u098f\u09b0 \u0989\u09aa\u09b0 \u09ad\u09bf\u09a4\u09cd\u09a4\u09bf \u0995\u09b0\u09c7 virtual table \u09a4\u09c8\u09b0\u09bf\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 view \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09df\u0964<br \/>\nView \u098f\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 real table \u098f\u09b0 \u09ae\u09a4\u09cb\u0987 rows \u098f\u09ac\u0982 columns \u09a5\u09be\u0995\u09c7\u0964 View \u098f\u09b0 fields \u0997\u09c1\u09b2\u09cb database \u098f\u09b0 \u098f\u0995 \u09ac\u09be \u098f\u0995\u09be\u09a7\u09bf\u0995 real table \u09b9\u09a4\u09c7 \u09a8\u09c7\u09df\u09be \u09b9\u09df\u0964<br \/>\nview \u098f\u09ac\u0982 present \u0995\u09b0\u09be\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09af\u09a6\u09bf \u098f\u0995\u099f\u09bf \u09ae\u09be\u09a4\u09cd\u09b0 table \u09b9\u09a4\u09c7 data \u09a8\u09c7\u09df\u09be \u09b9\u09df \u09a4\u09be\u09b9\u09b2\u09c7 WHERE \u0993 JOIN \u098f\u09b0 \u09ae\u09a4\u09cb SQL functions \u0997\u09c1\u09b2\u09cb add \u0995\u09b0\u09be \u09af\u09be\u09ac\u09c7\u0964<\/p>\n<p>SQL CREATE VIEW Syntax<br \/>\nCREATE VIEW view_name AS<br \/>\nSELECT column_name(s)<br \/>\nFROM table_name<br \/>\nWHERE condition<br \/>\n\u09a8\u09cb\u099f: view \u098f\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 \u09b8\u09ac\u09b0\u09cd\u09a6\u09be\u0987 \u09b9\u09be\u09b2\u09a8\u09be\u0997\u09be\u09a6 \u09ac\u09be up-to-date data \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09df\u0964 \u0995\u09cb\u09a8\u09cb user \u09af\u0996\u09a8 SQL statement view \u098f\u09b0 \u099c\u09a8\u09cd\u09af query \u0995\u09b0\u09c7 \u09a4\u0996\u09a8 database engine \u09a1\u09be\u099f\u09be\u0995\u09c7 recreate \u0995\u09b0\u09c7 \u09a6\u09c7\u0996\u09be\u09df\u0964<\/p>\n<p>SQL CREATE VIEW Examples<br \/>\n\u0986\u09aa\u09a8\u09be\u09b0 \u0995\u09be\u099b\u09c7 \u09af\u09a6\u09bf Northwind database \u099f\u09bf \u09a5\u09be\u0995\u09c7 \u09a4\u09be\u09b9\u09b2\u09c7 \u0986\u09aa\u09a8\u09bf \u09a6\u09c7\u0996\u09ac\u09c7\u09a8 \u09af\u09c7 \u09b8\u09c7\u0996\u09be\u09a8\u09c7 by default \u0985\u09a8\u09c7\u0995\u0997\u09c1\u09b2\u09cb view \u0987\u09a8\u09cd\u09b8\u099f\u09b2 \u09b0\u09df\u09c7\u099b\u09c7\u0964<br \/>\n&#8220;Current Product List&#8221; View \u099f\u09bf\u09a4\u09c7 \u09b6\u09c1\u09a7\u09c1\u09ae\u09be\u09a4\u09cd\u09b0 active product \u0997\u09c1\u09b2\u09cb\u0995\u09c7 \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09df, \u0985\u09b0\u09cd\u09a5\u09be\u09ce \u09af\u09c7\u09b8\u0995\u09b2 product active \u09a8\u09df \u09ac\u09be \u09aa\u09b0\u09ac\u09b0\u09cd\u09a4\u09c0\u09a4\u09c7 discontinue \u0995\u09b0\u09c7\u099b\u09c7 \u09b8\u09c7\u0997\u09c1\u09b2\u09cb\u0995\u09c7 \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09df\u09a8\u09bf\u0964 \u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4 SQL \u098f\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 View \u099f\u09bf \u09aa\u09cd\u09b0\u09b8\u09cd\u09a4\u09c1\u09a4 \u0995\u09b0\u09be \u09b9\u09df\u09c7\u099b\u09c7\u0964<br \/>\nCREATE VIEW [Current Product List] AS<br \/>\nSELECT ProductID,ProductName<br \/>\nFROM Products<br \/>\nWHERE Discontinued=No<\/p>\n<p>\u0986\u09ae\u09b0\u09be \u098f\u0987 View \u099f\u09bf \u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4\u09ad\u09be\u09ac\u09c7 query \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964<br \/>\nSELECT * FROM [Current Product List]<\/p>\n<p>Northwind sample database \u098f\u09b0 \u0985\u09a8\u09cd\u09af \u0986\u09b0\u09c7\u0995\u099f\u09bf View \u098f\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 &#8220;Products&#8221; table \u098f\u09b0 \u09af\u09c7\u09b8\u0995\u09b2 Product \u098f\u09b0 unit price \u0997\u09dc \u09ac\u09be average unit price \u098f\u09b0 \u099a\u09c7\u09df\u09c7 \u09ac\u09c7\u09b6\u09bf \u09b8\u09c7\u0997\u09c1\u09b2\u09cb\u0995\u09c7 \u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4\u09ad\u09be\u09ac\u09c7 \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09af\u09be\u09df:<br \/>\nCREATE VIEW [Products Above Average Price] AS<br \/>\nSELECT ProductName,UnitPrice<br \/>\nFROM Products<br \/>\nWHERE UnitPrice&gt;(SELECT AVG(UnitPrice) FROM Products)<\/p>\n<p>\u0986\u09ae\u09b0\u09be \u098f\u0987 View \u099f\u09bf \u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4\u09ad\u09be\u09ac\u09c7 query \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964<br \/>\nSELECT * FROM [Products Above Average Price]<\/p>\n<p>Northwind sample database \u098f\u09b0 \u0985\u09a8\u09cd\u09af \u0986\u09b0\u09c7\u0995\u099f\u09bf View \u098f\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09aa\u09cd\u09b0\u09a4\u09cd\u09af\u09c7\u0995 category \u09a4\u09c7 1997 \u09b8\u09be\u09b2\u09c7\u09b0 \u09ae\u09cb\u099f \u09ac\u09bf\u0995\u09cd\u09b0\u09df \u09ac\u09be total sale \u098f\u09b0 calculation \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09df\u09c7\u099b\u09c7\u0964 \u098f\u0996\u09be\u09a8\u09c7 \u0989\u09b2\u09cd\u09b2\u09c7\u0996\u09cd\u09af \u09af\u09c7, \u098f\u0987 View \u098f\u09b0 \u09a1\u09be\u099f\u09be\u0997\u09c1\u09b2\u09cb \u0985\u09a8\u09cd\u09af \u0986\u09b0\u09c7\u0995\u099f\u09bf View &#8220;Product Sales for 1997&#8221; \u09b9\u09a4\u09c7 \u09a8\u09c7\u09df\u09be \u09b9\u09df\u0964<br \/>\nCREATE VIEW [Category Sales For 1997] AS<br \/>\nSELECT DISTINCT CategoryName,Sum(ProductSales) AS CategorySales<br \/>\nFROM [Product Sales for 1997]<br \/>\nGROUP BY CategoryName<\/p>\n<p>\u0986\u09ae\u09b0\u09be \u098f\u0987 View \u099f\u09bf \u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4\u09ad\u09be\u09ac\u09c7 query \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964<br \/>\nSELECT * FROM [Category Sales For 1997]<br \/>\n\u0986\u09ae\u09b0\u09be \u098f\u0987 query \u09a4\u09c7 condition \u09af\u09cb\u0997 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964 \u0986\u09ae\u09b0\u09be \u09b6\u09c1\u09a7\u09c2 \u09ae\u09be\u09a4\u09cd\u09b0 &#8220;Beverages&#8221; Category \u098f\u09b0 total sale \u09a6\u09c7\u0996\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4\u09ad\u09be\u09ac\u09c7 query \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964<br \/>\nSELECT * FROM [Category Sales For 1997]<br \/>\nWHERE CategoryName=&#8217;Beverages&#8217;<\/p>\n<p>SQL Updating a View<br \/>\n\u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4 syntax \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 View \u0995\u09c7 update \u0995\u09b0\u09be \u09af\u09c7\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u0964<\/p>\n<p>SQL CREATE \u0985\u09a5\u09ac\u09be REPLACE VIEW Syntax<br \/>\nCREATE OR REPLACE VIEW view_name AS<br \/>\nSELECT column_name(s)<br \/>\nFROM table_name<br \/>\nWHERE condition<\/p>\n<p>\u098f\u0996\u09a8 \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be &#8220;Current Product List&#8221; view \u098f &#8220;Category&#8221; column \u099f\u09bf \u09af\u09cb\u0997 \u0995\u09b0\u09a4\u09c7 \u099a\u09be\u0987, \u09a4\u09be\u09b9\u09b2\u09c7 \u09a8\u09bf\u09ae\u09cd\u09a8\u09cb\u0995\u09cd\u09a4 SQL \u098f\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 View \u099f\u09bf\u0995\u09c7 update \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964<br \/>\nCREATE VIEW [Current Product List] AS<br \/>\nSELECT ProductID,ProductName,Category<br \/>\nFROM Products<br \/>\nWHERE Discontinued=No<\/p>\n<p>SQL Dropping a View<br \/>\nDROP VIEW command \u098f\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 \u0995\u09cb\u09a8\u09cb View \u0995\u09c7 delete \u0995\u09b0\u09be \u09af\u09be\u09df\u0964<br \/>\nSQL DROP VIEW Syntax<br \/>\nDROP VIEW view_name<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Title: SQL Views \u0985\u09a8\u09c1\u09ac\u09be\u09a6\u0995: \u09ab\u09df\u09b8\u09be\u09b2 \u09b0\u0995\u09bf (\u098f\u09ae.\u098f) Total words in the article: 478 SQL \u098f view \u09ac\u09b2\u09a4\u09c7 virtual table \u098f\u09b0 view \u0995\u09c7 \u09ac\u09cb\u099d\u09be\u09df, \u0985\u09b0\u09cd\u09a5\u09be\u09ce real table \u0995\u09c7 virtually \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09b9\u09df\u0964 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 view create, update \u09ac\u09be delete \u0995\u09b0\u09be \u09b9\u09df \u09a4\u09be \u098f\u0987 \u0985\u09a7\u09cd\u09af\u09be\u09df\u09c7 \u0986\u09b2\u09cb\u099a\u09a8\u09be \u0995\u09b0\u09be \u09b9\u09ac\u09c7\u0964 SQL CREATE VIEW Statement SQL statement \u098f\u09b0 result-set \u098f\u09b0 \u0989\u09aa\u09b0 \u09ad\u09bf\u09a4\u09cd\u09a4\u09bf &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=5965\">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-5965","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":5941,"url":"http:\/\/bangla.sitestree.com\/?p=5941","url_meta":{"origin":5965,"position":0},"title":"SQL DROP INDEX, DROP TABLE, and DROP DATABASE","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"Title: SQL DROP INDEX, DROP TABLE, and DROP DATABASE \u0985\u09a8\u09c1\u09ac\u09be\u09a6\u0995: \u09ab\u09df\u09b8\u09be\u09b2 \u09b0\u0995\u09bf (\u098f\u09ae.\u098f) Total word count: 164 DROP statement \u098f\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 Indexes, tables \u0995\u09bf\u0982\u09ac\u09be databases \u0995\u09c7 \u09b8\u09b9\u099c\u09c7\u0987 deleted \u09ac\u09be removed \u0995\u09b0\u09be \u09af\u09be\u09df\u0964 The DROP INDEX Statement DROP INDEX statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf table \u098f\u09b0 \u098f\u0995\u099f\u09bf index \u0995\u09c7 delete \u0995\u09b0\u09be \u09af\u09be\u09df\u0964\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":5939,"url":"http:\/\/bangla.sitestree.com\/?p=5939","url_meta":{"origin":5965,"position":1},"title":"Title: SQL CREATE INDEX Statement . SQL Create Index Statement","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"Title: SQL CREATE INDEX Statement \u0985\u09a8\u09c1\u09ac\u09be\u09a6\u0995: \u09ab\u09df\u09b8\u09be\u09b2 \u09b0\u0995\u09bf (\u098f\u09ae.\u098f) Total word count: 247 ----------------------------------------------------- CREATE INDEX \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f\u09c7\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 \u0995\u09cb\u09a8\u09cb table \u098f\u09b0 index \u09aa\u09cd\u09b0\u09b8\u09cd\u09a4\u09c1\u09a4 \u0995\u09b0\u09be \u09b9\u09df\u0964 index \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 database application \u098f\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 \u0995\u09cb\u09a8 table \u098f\u09b0 \u09ae\u09a7\u09cd\u09af\u0995\u09be\u09b0 data \u0995\u09c7 \u09b8\u09b9\u099c\u09c7 \u0996\u09c1\u0981\u099c\u09c7 \u09ac\u09c7\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df\u0964 \u098f\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09aa\u09c1\u09b0\u09cb table \u099f\u09bf \u0996\u09c1\u0981\u099c\u09a4\u09c7 \u09b9\u09df \u09a8\u09be,\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":8026,"url":"http:\/\/bangla.sitestree.com\/?p=8026","url_meta":{"origin":5965,"position":2},"title":"jQuery &#8211; AJAX \u098f\u09b0 get() and post() \u09ae\u09c7\u09a5\u09a1 \u0964 jQuery &#8211; AJAX get() and post() Methods","author":"Author-Check- Article-or-Video","date":"March 29, 2015","format":false,"excerpt":"\u0985\u09a8\u09c1\u09ac\u09be\u09a6\u0995: \u09ab\u09df\u09b8\u09be\u09b2 \u09b0\u0995\u09bf \u00a0 \u099c\u09c7\u0995\u09c1\u09df\u09c7\u09b0\u09bf - \u098f\u099c\u09be\u0995\u09cd\u09b8 get() \u098f\u09ac\u0982 post() \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 HTTP GET \u09ac\u09be POST request \u09ac\u09be \u0985\u09a8\u09c1\u09c7\u09b0\u09be\u09a7-\u098f\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 data request \u09aa\u09be\u09a0\u09be\u09a8\u09cb \u09b9\u09df\u0964 HTTP request: GET \u09ac\u09a8\u09be\u09ae POST \u0995\u09cd\u09b2\u09be\u0987\u09a8\u09cd\u099f \u0993 \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7\u09b0 \u09ae\u09a7\u09cd\u09af\u0995\u09be\u09b0 request \u0993 response \u098f\u09b0 \u099c\u09a8\u09cd\u09af \u09ac\u09b9\u09c1\u09b2 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf \u09a6\u09c1\u099f\u09bf \u09b9\u09b2\u09cb GET \u0993 POST. GET: \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f\u2026","rel":"","context":"In &quot;jQuery-001 \u0964 \u099c\u09c7 \u0995\u09c1\u09df\u09c7\u09b0\u09bf - \u09e6\u09e6\u09e7&quot;","block_context":{"text":"jQuery-001 \u0964 \u099c\u09c7 \u0995\u09c1\u09df\u09c7\u09b0\u09bf - \u09e6\u09e6\u09e7","link":"http:\/\/bangla.sitestree.com\/?cat=152"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6061,"url":"http:\/\/bangla.sitestree.com\/?p=6061","url_meta":{"origin":5965,"position":3},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09eb \u09a4\u09be\u09b0\u09bf\u0996 \u0993 \u09b8\u09ae\u09df (PHP 5 Date and Time)","author":"Author-Check- Article-or-Video","date":"March 10, 2015","format":false,"excerpt":"PHP Date() \u09ab\u09be\u0982\u09b6\u09a8 PHP Date() \u09ab\u09be\u0982\u09b6\u09a8 \u098f\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 \u09b8\u09b9\u099c\u09c7 \u0993 \u09b8\u09a0\u09bf\u0995\u09ad\u09be\u09ac\u09c7 \u09b8\u09ae\u09df (time) \u0993 \u09a4\u09be\u09b0\u09bf\u0996 (date) \u09a6\u09c7\u0996\u09be\u09a8\u09cb \u09af\u09be\u09df\u0964 \u09b8\u09bf\u09a8\u099f\u09c7\u0995\u09cd\u09b8 date(format,timestamp) \u00a0 \u09aa\u09cd\u09af\u09be\u09b0\u09be\u09ae\u09bf\u099f\u09be\u09b0 \u09ac\u09b0\u09cd\u09a3\u09a8\u09be format \u0986\u09ac\u09b6\u09cd\u09af\u09bf\u0995 \u09ac\u09be Required. \u098f\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 timestamp \u098f\u09b0 \u09ab\u09b0\u09ae\u09c7\u099f \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u0995\u09b0\u09be \u09b9\u09df\u0964 timestamp \u0990\u099a\u09cd\u099b\u09bf\u0995 \u09ac\u09be Optional. \u098f\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 timestamp \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u0995\u09b0\u09be \u09b9\u09df\u0964 \u09b8\u09be\u09a7\u09be\u09b0\u09a3\u09a4 Default \u09b9\u09bf\u09b8\u09be\u09ac\u09c7 current \u09b8\u09ae\u09df\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":6808,"url":"http:\/\/bangla.sitestree.com\/?p=6808","url_meta":{"origin":5965,"position":4},"title":"\u098f\u0987\u099a\u099f\u09bf\u098f\u09ae\u098f\u09b2 \u0987\u0989\u09a8\u09bf\u09ab\u09b0\u09cd\u09ae \u09b0\u09bf\u09b8\u09cb\u09b0\u09cd\u09b8 \u09b2\u09cb\u0995\u09c7\u099f\u09b0 (HTML Uniform Resource Locators)","author":"Author-Check- Article-or-Video","date":"April 10, 2015","format":false,"excerpt":"\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae Job category-Php Coder \u00a0 \u0993\u09df\u09c7\u09ac \u09a0\u09bf\u0995\u09be\u09a8\u09be\u09b0 \u0985\u09a8\u09cd\u09af \u09a8\u09be\u09ae \u09b9\u099a\u09cd\u099b\u09c7 URL \u098f\u0995\u099f\u09bf URL \u09b2\u09c7\u0996\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u099f\u09be\u0987\u09aa \u0995\u09b0\u09a4\u09c7 \u09b9\u09df \u09b6\u09ac\u09cd\u09a6\u09c7\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 (http:\/\/bangla.salearningschool.com) \u09ac\u09be \u0987\u09a8\u09cd\u099f\u09be\u09b0\u09a8\u09c7\u099f \u09aa\u09cd\u09b0\u099f\u09cb\u0995\u09b2 \u098f\u09a1\u09cd\u09b0\u09c7\u09b8 (IP) \u099f\u09be\u0987\u09aa \u0995\u09b0\u09c7, \u09af\u09c7\u09ae\u09a8 (192.185.24.202)\u0964 \u09aa\u09cd\u09b0\u09be\u09df \u09b8\u09ac\u09be\u0987 \u098f\u09a1\u09cd\u09b0\u09c7\u09b8 \u09ac\u09be\u09b0\u09c7 \u09a1\u09cb\u09ae\u09c7\u0987\u09a8 \u09a8\u09be\u09ae\u0995\u09c7 \u099f\u09be\u0987\u09aa \u0995\u09b0\u09c7 \u09a5\u09be\u0995\u09c7 \u0995\u09be\u09b0\u09a8 \u09a8\u09be\u09ae\u09cd\u09ac\u09be\u09b0 \u098f\u09b0 \u09a5\u09c7\u0995\u09c7 \u09a8\u09be\u09ae \u09ae\u09a8\u09c7 \u09b0\u09be\u0996\u09be \u09b8\u09b9\u099c\u0964 \u00a0\u2026","rel":"","context":"In &quot;\u098f\u0987\u099a\u099f\u09bf\u098f\u09ae\u098f\u09b2 HTML&quot;","block_context":{"text":"\u098f\u0987\u099a\u099f\u09bf\u098f\u09ae\u098f\u09b2 HTML","link":"http:\/\/bangla.sitestree.com\/?cat=494"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5813,"url":"http:\/\/bangla.sitestree.com\/?p=5813","url_meta":{"origin":5965,"position":5},"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 &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\/5965","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=5965"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5965\/revisions"}],"predecessor-version":[{"id":5966,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5965\/revisions\/5966"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5965"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}