{"id":5967,"date":"2015-01-30T23:59:29","date_gmt":"2015-01-31T04:59:29","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5967"},"modified":"2015-09-03T08:12:35","modified_gmt":"2015-09-03T12:12:35","slug":"sql-date-functions","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5967","title":{"rendered":"SQL Date Functions"},"content":{"rendered":"<p>\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae<br \/>\nJob category-Php Coder<\/p>\n<p>\u09ac\u09bf\u09b7\u09df- SQL Date Functions<br \/>\n\u098f\u099f\u09bf \u098f\u0995\u099f\u09bf \u0995\u09a0\u09bf\u09a8 \u09ac\u09bf\u09b7\u09df \u09af\u0996\u09a8 \u0986\u09ae\u09b0\u09be date \u09a8\u09bf\u09df\u09c7 \u0995\u09be\u099c \u0995\u09b0\u09ac \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u09ad\u09be\u09ac\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 date format \u099c\u09c7\u09a8\u09c7 \u09a8\u09bf\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964\u0986\u09ae\u09b0\u09be date \u09a8\u09bf\u09df\u09c7 \u0995\u09be\u099c \u0995\u09b0\u09a4\u09c7 \u0997\u09c7\u09b2\u09c7 \u098f\u09b0 \u0995\u09df\u09c7\u0995\u099f\u09bf \u09ab\u09b0\u09ae\u09cd\u09af\u09be\u099f \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u099c\u09be\u09a8\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964<br \/>\nNow()-\u09ac\u09b0\u09cd\u09a4\u09ae\u09be\u09a8 \u09b8\u09ae\u09df \u098f\u09ac\u0982 \u09a4\u09be\u09b0\u09bf\u0996 \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7<br \/>\nCURDATE()-\u09ac\u09b0\u09cd\u09a4\u09ae\u09be\u09a8 \u09a4\u09be\u09b0\u09bf\u0996 \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7<br \/>\nCURTIME()-\u09ac\u09b0\u09cd\u09a4\u09ae\u09be\u09a8 \u09b8\u09ae\u09df \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7<br \/>\nEXTRACT()-\u09b8\u09ae\u09df\/\u09a4\u09be\u09b0\u09bf\u0996 \u098f\u09b0 \u098f\u0995\u099f\u09bf single \u09aa\u09be\u09b0\u09cd\u099f \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7\u0964<br \/>\nDATEDIFF()-\u09a6\u09c1\u099f\u09bf \u09a4\u09be\u09b0\u09bf\u0996\u09c7\u09b0 \u09ae\u09be\u099d\u09c7\u09b0 \u09b8\u09ae\u09df \u09a8\u09bf\u09b0\u09cd\u09a7\u09be\u09b0\u09a3 \u0995\u09b0\u09ac\u09c7\u0964<br \/>\nDATE_FORMAT()-\u09ad\u09bf\u09a8\u09cd\u09a8 \u09ad\u09bf\u09a8\u09cd\u09a8 format \u098f\u09b0 date\/time \u09a1\u09bf\u09b8\u09aa\u09cd\u09b2\u09c7 \u0995\u09b0\u09ac\u09c7\u0964<br \/>\n\u098f\u0996\u09a8 \u0986\u09ae\u09b0\u09be NOW() \u0995\u09be\u099c\u09c7 \u09b2\u09be\u0997\u09bf\u09df\u09c7 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09ac\u0964 \u09af\u09c7\u0995\u09cb\u09a8\u09cb \u098f\u0995\u099f\u09bf \u09a8\u09be\u09ae \u09a6\u09bf\u09df\u09c7 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09bf\u0964 SQL window \u09a4\u09c7 \u0997\u09bf\u09df\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 query \u099f\u09bf \u099a\u09be\u09b2\u09a8\u09be \u0995\u09b0\u09bf<br \/>\nCREATE TABLE Orders<br \/>\n(<br \/>\nOrderId int NOT NULL,<br \/>\nProductName varchar(50) NOT NULL,<br \/>\nOrderDate datetime NOT NULL DEFAULT NOW(),<br \/>\nPRIMARY KEY (OrderId)<br \/>\n)<br \/>\nSave \u09ac\u09be\u099f\u09a8 \u098f \u0995\u09cd\u09b2\u09bf\u0995 \u0995\u09b0\u09be\u09b0 \u09aa\u09b0 \u0986\u09ac\u09be\u09b0 sql window \u09a4\u09c7 \u0997\u09bf\u09df\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 \u0995\u09cb\u09a1 \u099f\u09c1\u0995\u09c1 \u099f\u09be\u0987\u09aa \u0995\u09b0\u09bf<br \/>\nINSERT INTO Orders (ProductName) VALUES (&#8216;Jarlsberg Cheese&#8217;)<br \/>\n\u098f\u09ac\u0982 \u09b0\u09be\u09a8 \u0995\u09b0\u09b2\u09c7 \u0986\u09ae\u09b0\u09be \u09a8\u09bf\u099a\u09c7\u09b0 \u09ae\u09a4\u09a8 \u09a6\u09c7\u0996\u09a4\u09c7 \u09aa\u09be\u09ac<br \/>\nOrderId ProductName OrderDate<br \/>\n1 Jarlsberg Cheese 2015-01-25 13:23:44.657<br \/>\n\u09ae\u09be\u09a8\u09c7 orderdate \u09b8\u09ae\u09df \u098f\u09ac\u0982 \u09a4\u09be\u09b0\u09bf\u0996 \u09b8\u09b9 \u0987\u09a8\u09aa\u09c1\u099f \u09b9\u09df\u09c7\u099b\u09c7\u0964\u098f\u0995\u099f\u09c1 \u09af\u09a6\u09bf \u09b2\u0995\u09cd\u09b7\u09cd\u09af \u0995\u09b0\u09bf \u0986\u09ae\u09b0\u09be orderdate \u098f \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be \u0995\u09bf\u09a8\u09cd\u09a4 \u0987\u09a8\u09aa\u09c1\u099f \u09b8\u09c7 \u0985\u099f\u09cb\u09ae\u09c7\u099f\u09bf\u0995 \u0995\u09ae\u09cd\u09aa\u09bf\u0989\u099f\u09be\u09b0 \u09a5\u09c7\u0995\u09c7 \u099f\u09be\u0987\u09ae \u0993 \u09a4\u09be\u09b0\u09bf\u0996 \u099c\u09c7\u09a8\u09c7 \u09a8\u09bf\u09df\u09c7 \u09a8\u09bf\u099c\u09c7\u0987 \u09ac\u09b8\u09bf\u09df\u09c7\u099b\u09c7\u0964 \u0985\u09b0\u09cd\u09a5\u09be\u09ce \u09af\u09a6\u09bf<br \/>\nNOW() \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u099a\u09be\u0987\u09b2\u09c7 \u09b2\u09bf\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7<br \/>\nOrderDate datetime NOT NULL DEFAULT NOW()<br \/>\nCURDATE()\u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u099a\u09be\u0987\u09b2\u09c7 \u09b2\u09bf\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7<br \/>\nOrderDate datetime NOT NULL DEFAULT CURDATE()<br \/>\nCURTIME()\u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u099a\u09be\u0987\u09b2\u09c7 \u09b2\u09bf\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7<br \/>\nOrderDate datetime NOT NULL DEFAULT CURTIME()<br \/>\nSQL QUERY \u098f\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be date select \u0995\u09b0\u09c7 \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be \u09ac\u09c7\u09b0 \u0995\u09b0\u09a4\u09c7 \u099a\u09be\u0987<br \/>\n\u09a4\u09be\u09b9\u09b2\u09c7 \u09b2\u09bf\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7<br \/>\nSELECT NOW(),CURDATE(),CURTIME()<br \/>\n\u098f\u09ac\u0982 \u0986\u09ae\u09b0\u09be \u09af\u09c7 \u09ab\u09b2\u09be\u09ab\u09b2 \u09a4\u09be \u09aa\u09be\u09ac<br \/>\nNOW() CURDATE() CURTIME()<br \/>\n2015-01-25 12:45:34 2015-01-25 12:45:34<\/p>\n<p>\u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be \u09a6\u09c1\u099f\u09bf date \u098f\u09b0 \u09ae\u09be\u099d\u09c7 difference \u0996\u09c1\u099c\u09c7 \u09aa\u09c7\u09a4\u09c7 \u099a\u09be\u0987 \u09a4\u09be\u09b9\u09b2\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac<br \/>\nSELECT DATEDIFF(&#8216;2014-11-30&#8242;,&#8217;2014-11-29&#8242;) AS DiffDate<br \/>\n\u09a4\u09be\u09b9\u09b2\u09c7 \u09ab\u09b2\u09be\u09ab\u09b2 \u0986\u09b8\u09ac\u09c7 \u09e7<br \/>\n\u098f\u0996\u09a8 \u0986\u09b8\u09be \u09af\u09be\u0995 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 date format \u09a0\u09bf\u0995 \u0995\u09b0\u09a4\u09c7 \u09b9\u09df<br \/>\nSYNTAX<br \/>\nDATE_FORMAT(date,format)<br \/>\ndate \u09ab\u09b0\u09ae\u09cd\u09af\u09be\u099f \u09a0\u09bf\u0995 \u09b0\u09be\u0996\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09b0\u09be \u0995\u09bf\u099b\u09c1 \u09ab\u09bf\u099a\u09be\u09b0 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf<br \/>\n%a=\u09b8\u09aa\u09cd\u09a4\u09be\u09b9\u09c7\u09b0 \u09a6\u09bf\u09a8\u09c7\u09b0 \u09a8\u09be\u09ae<br \/>\n%b=\u09ae\u09be\u09b8\u09c7\u09b0 \u09a8\u09be\u09ae<br \/>\n%c=\u09ae\u09be\u09b8 numeric<br \/>\n%D=\u09a6\u09bf\u09a8 \u0987\u0982\u09b2\u09bf\u09b6 suffix \u0985\u09a8\u09c1\u09af\u09be\u09df\u09c0<br \/>\n%d= \u09a6\u09bf\u09a8 numeric(00-31)<br \/>\n%e=\u09a6\u09bf\u09a8 numeric(0-31)<br \/>\n%H=\u0998\u09a3\u09cd\u099f\u09be (00-23)<br \/>\n%h=\u0998\u09a3\u09cd\u099f\u09be (01-12)<br \/>\n%I= \u0998\u09a3\u09cd\u099f\u09be (01-12)<br \/>\n%i=minutes numeric(00-59)<br \/>\n%M=\u09ae\u09be\u09b8\u09c7\u09b0 \u09a8\u09be\u09ae<br \/>\n%m=\u09ae\u09be\u09b8\u09c7\u09b0 \u09a8\u09be\u09ae numeric(01-12)<br \/>\n%p=AM\/PM<br \/>\n%s=\u09b8\u09c7\u0995\u09c7\u09a8\u09cd\u09a1 (00-59)<br \/>\n%W=\u09b8\u09aa\u09cd\u09a4\u09be\u09b9\u09c7\u09b0 \u09a8\u09be\u09ae<br \/>\n%w=\u09b8\u09aa\u09cd\u09a4\u09be\u09b9\u09c7\u09b0 \u09a8\u09be\u09ae numeric(01-07)<br \/>\n%Y=\u09ac\u099b\u09b0 \u09ea \u09a1\u09bf\u099c\u09bf\u099f<br \/>\n%y=\u09ac\u099b\u09b0 \u09e8 \u09a1\u09bf\u099c\u09bf\u099f<br \/>\nSQL query \u098f\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be \u09b2\u09bf\u0996\u09bf<br \/>\nDATE_FORMAT(NOW(),&#8217;%b %d %Y %h:%i %p&#8217;)<br \/>\nDATE_FORMAT(NOW(),&#8217;%m-%d-%Y&#8217;)<br \/>\nDATE_FORMAT(NOW(),&#8217;%d %b %y&#8217;)<br \/>\nDATE_FORMAT(NOW(),&#8217;%d %b %Y %T:%f&#8217;)<br \/>\n\u09a4\u09be\u09b9\u09b2\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u09ab\u09b2\u09be\u09ab\u09b2 \u0986\u09b8\u09ac\u09c7<br \/>\nNov 04 2014 11:45 PM<br \/>\n11-04-2014<br \/>\n04 Nov 14<br \/>\n04 Nov 2014 11:45:34:243<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae Job category-Php Coder \u09ac\u09bf\u09b7\u09df- SQL Date Functions \u098f\u099f\u09bf \u098f\u0995\u099f\u09bf \u0995\u09a0\u09bf\u09a8 \u09ac\u09bf\u09b7\u09df \u09af\u0996\u09a8 \u0986\u09ae\u09b0\u09be date \u09a8\u09bf\u09df\u09c7 \u0995\u09be\u099c \u0995\u09b0\u09ac \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u09ad\u09be\u09ac\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 date format \u099c\u09c7\u09a8\u09c7 \u09a8\u09bf\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964\u0986\u09ae\u09b0\u09be date \u09a8\u09bf\u09df\u09c7 \u0995\u09be\u099c \u0995\u09b0\u09a4\u09c7 \u0997\u09c7\u09b2\u09c7 \u098f\u09b0 \u0995\u09df\u09c7\u0995\u099f\u09bf \u09ab\u09b0\u09ae\u09cd\u09af\u09be\u099f \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u099c\u09be\u09a8\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 Now()-\u09ac\u09b0\u09cd\u09a4\u09ae\u09be\u09a8 \u09b8\u09ae\u09df \u098f\u09ac\u0982 \u09a4\u09be\u09b0\u09bf\u0996 \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7 CURDATE()-\u09ac\u09b0\u09cd\u09a4\u09ae\u09be\u09a8 \u09a4\u09be\u09b0\u09bf\u0996 \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7 CURTIME()-\u09ac\u09b0\u09cd\u09a4\u09ae\u09be\u09a8 \u09b8\u09ae\u09df \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7 EXTRACT()-\u09b8\u09ae\u09df\/\u09a4\u09be\u09b0\u09bf\u0996 \u098f\u09b0 \u098f\u0995\u099f\u09bf &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=5967\">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-5967","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":5886,"url":"http:\/\/bangla.sitestree.com\/?p=5886","url_meta":{"origin":5967,"position":0},"title":"SQL Insert Into Statement","author":"Author-Check- Article-or-Video","date":"January 31, 2015","format":false,"excerpt":"\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae Job category-Php Coder \u09ac\u09bf\u09b7\u09df- SQL Insert Into Statement Database \u098f\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be insert \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09b0\u09be insert statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u09a5\u09be\u0995\u09bf\u0964 \u098f\u09b0\u099c\u09a8\u09cd\u09a8 \u0986\u0997\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7 \u09a8\u09bf\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u0986\u09ae\u09b0\u09be \u09aa\u09cd\u09b0\u09cb\u09a1\u09be\u0995\u09cd\u099f \u09a8\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09be \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09ac \u098f\u09ac\u0982 \u09a4\u09be\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09ac\u0964 \u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u098f\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":5888,"url":"http:\/\/bangla.sitestree.com\/?p=5888","url_meta":{"origin":5967,"position":1},"title":"SQL Update Statement","author":"Author-Check- Article-or-Video","date":"January 31, 2015","format":false,"excerpt":"\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae PHP Coder \u09ac\u09bf\u09b7\u09df- SQL Update Statement SQL Update statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u098f\u09b0 \u09ad\u09bf\u09a4\u09b0\u09c7 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09a1\u09be\u099f\u09be \u0995\u09c7 \u09aa\u09b0\u09bf\u09ac\u09b0\u09a4\u09a8 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af\u0964 \u098f\u0987 statement \u098f\u09b0 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u0985\u09cd\u09af\u09be\u09aa\u09cd\u09b2\u09be\u0987 \u0995\u09b0\u09a4\u09c7 \u09b9\u09df \u09a4\u09be \u09a6\u09c7\u0996\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09be\u09a6\u09c7\u09b0 localhost>phpmyadmin \u098f\u09b0 \u0986\u09a8\u09cd\u09a1\u09be\u09b0 \u098f \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u098f\u09ac\u0982 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u09aa\u09cd\u09b0\u09a5\u09ae\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":5947,"url":"http:\/\/bangla.sitestree.com\/?p=5947","url_meta":{"origin":5967,"position":2},"title":"SQL Not Null Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae Job category-Php Coder \u09ac\u09bf\u09b7\u09df- SQL Not Null Constraint Null \u098f\u09b0 \u0985\u09b0\u09cd\u09a5 \u0995\u09cb\u09a8 \u099c\u09be\u0987\u0997\u09be \u09ab\u09be\u0995\u09be \u09a5\u09be\u0995\u09be\u0964\u09b8\u09be\u09a7\u09be\u09b0\u09a8\u09a4 \u0995\u09cb\u09a8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09ab\u09bf\u09b2\u09cd\u09a1 \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be \u0995\u09cb\u09a8 \u0995\u09bf\u099b\u09c1 \u09a8\u09be \u0987\u09a8\u09aa\u09c1\u099f \u0995\u09b0\u09c7 \u09a5\u09be\u0995\u09bf \u098f\u09ac\u0982 \u09b8\u09c7\u09ad \u0995\u09b0\u09bf \u09a4\u09be\u09b9\u09b2\u09c7 \u099c\u09be\u0987\u0997\u09be \u099f\u09be \u09ab\u09be\u0995\u09be \u09a5\u09be\u0995\u09c7 \u0995\u09bf\u09a8\u09cd\u09a4\u09c1 mysql database \u098f \u09b8\u09c7\u099f\u09bf\u0982\u09b8\u09cd\u200c \u09a0\u09bf\u0995 \u0995\u09b0\u09c7 \u09a6\u09bf\u09b2\u09c7 \u09b8\u09c7\u0987 \u099c\u09be\u0987\u0997\u09be \u0986\u09ae\u09b0\u09be \u09af\u09a4\u0995\u09cd\u09b7\u09a3 \u09aa\u09b0\u09cd\u09af\u09a8\u09cd\u09a4\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5963,"url":"http:\/\/bangla.sitestree.com\/?p=5963","url_meta":{"origin":5967,"position":3},"title":"SQL statement \u098f ALTER FUNCTION \u098f\u09b0 \u09ac\u09be\u09ac\u09b9\u09be\u09b0 . SQL Alter Table Statement","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"\u09a8\u09be\u09ae-\u09b6\u09be\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae Job category-Php Coder \u09ac\u09bf\u09b7\u09df- SQL statement \u098f ALTER FUNCTION \u098f\u09b0 \u09ac\u09be\u09ac\u09b9\u09be\u09b0 Alter \u098f\u0987 statement \u099f\u09bf mysql \u098f \u09ac\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df database table \u098f\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u0995\u09bf\u099b\u09c1 \u09ab\u09bf\u09b2\u09cd\u09a1 \u09af\u09cb\u0997 ,\u09ac\u09be\u09a6 \u09ac\u09be \u09b8\u0982\u09af\u09cb\u099c\u09a8 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af\u0964 \u0986\u09b8\u09b2\u09c7 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u0995\u09b0\u09a4\u09c7 \u09b9\u09df \u09a4\u09be \u0986\u09ae\u09b0\u09be \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be\u09b0 \u09ae\u09be\u09a7\u09ae\u09c7 \u099c\u09be\u09a8\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac \u098f\u09ac\u0982 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u09b8\u09c7\u0996\u09be\u09a8\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":8469,"url":"http:\/\/bangla.sitestree.com\/?p=8469","url_meta":{"origin":5967,"position":4},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a4\u09cd\u09b0\u09c1\u099f\u09bf \u09aa\u09b0\u09bf\u099a\u09be\u09b2\u09a8\u09be\u09b0 \u09ac\u09cd\u09af\u09ac\u09b8\u09cd\u09a5\u09be (PHP Error Handling)","author":"Author-Check- Article-or-Video","date":"March 24, 2015","format":false,"excerpt":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae\u09bf\u0982 \u098f \u098f\u0995\u099f\u09bf Default Error Handling built-in \u09a5\u09be\u0995\u09c7 \u09af\u09be \u09b8\u09cd\u09ac\u09df\u0982\u0995\u09cd\u09b0\u09bf\u09df \u09ad\u09be\u09ac\u09c7 \u09af\u09c7 \u09ab\u09be\u0987\u09b2\u09c7 \u09ad\u09c1\u09b2 \u09b0\u09df\u09c7\u099b\u09c7 \u09b8\u09c7\u0987 \u09ab\u09be\u0987\u09b2\u09c7\u09b0 \u09a8\u09be\u09ae, \u09af\u09c7 \u09b2\u09be\u0987\u09a8 \u098f \u09ad\u09c1\u09b2 \u09b9\u09df\u09c7\u099b\u09c7 \u09a4\u09be\u09b0 \u09a8\u09ae\u09cd\u09ac\u09b0 \u098f\u09ac\u0982 \u0995\u09bf \u09a7\u09b0\u09a8\u09c7\u09b0 \u09ad\u09c1\u09b2 \u09b9\u09df\u09c7\u099b\u09c7 \u09a4\u09be \u09aa\u09cd\u09b0\u09a6\u09b0\u09cd\u09b6\u09a8 \u0995\u09b0\u09c7 \u09a5\u09be\u0995\u09c7 \u098f\u09ac\u0982 \u09ac\u09cd\u09b0\u09be\u0989\u09b8\u09be\u09b0\u09c7 \u098f\u0995\u099f\u09bf error message \u09aa\u09cd\u09b0\u09c7\u09b0\u09a8 \u0995\u09b0\u09c7\u0964 \u0986\u09ae\u09b0\u09be \u0989\u0995\u09cd\u09a4 error message \u09a6\u09c7\u0996\u09c7 \u0996\u09c1\u09ac \u09b8\u09b9\u099c\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0\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":11247,"url":"http:\/\/bangla.sitestree.com\/?p=11247","url_meta":{"origin":5967,"position":5},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf\u0983 \u0987\u09a8\u09cd\u099f\u09be\u09b0\u09ad\u09bf\u0989\u09df\u09c7\u09b0 \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8\u09be\u09ac\u09b2\u09c0 \u098f\u09ac\u0982 \u0989\u09a4\u09cd\u09a4\u09b0\u09b8\u09ae\u09c2\u09b9\u0964 PHP Interview Questions and Answers","author":"Author-Check- Article-or-Video","date":"November 9, 2015","format":false,"excerpt":"\u09b0\u09bf\u09a6\u0993\u09df\u09be\u09a8 \u09ac\u09bf\u09a8 \u09b6\u09be\u09ae\u09c0\u09ae \u00a0 \u09aa\u09cd\u09b0\u09bf\u09df \u09aa\u09be\u09a0\u0995, \u0986\u09aa\u09a8\u09be\u09b0\u09be \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09ac\u09bf\u09b7\u09df\u0995 \u0987\u09a8\u09cd\u099f\u09be\u09b0\u09ad\u09bf\u0989\u09a4\u09c7 \u09af\u09c7 \u09a7\u09b0\u09a8\u09c7\u09b0 \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8\u09c7\u09b0 \u09b8\u09ae\u09cd\u09ae\u09c1\u0996\u09c0\u09a8 \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u09a8 \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09ae\u09b0\u09be \u09b8\u09c7 \u09a7\u09b0\u09a8\u09c7\u09b0 \u0995\u09bf\u099b\u09c1 \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8\u09c7\u09b0 \u09a7\u09be\u09b0\u09be \u09a6\u09c7\u0996\u09bf\u09df\u09c7\u099b\u09bf\u0964 \u0985\u09ad\u09bf\u099c\u09cd\u099e\u09a4\u09be \u09a5\u09c7\u0995\u09c7 \u09ac\u09b2\u099b\u09bf, \u09ad\u09be\u09b2 \u09b8\u09be\u0995\u09cd\u09b7\u09be\u09ce\u0995\u09be\u09b0 \u0997\u09cd\u09b0\u09b9\u09a3\u0995\u09be\u09b0\u09c0\u09b0\u09be \u0995\u09cb\u09a8\u0993 \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8 \u09aa\u09cd\u09b2\u09cd\u09af\u09be\u09a8\u09ae\u09be\u09ab\u09bf\u0995 \u0995\u09b0\u09c7\u09a8 \u09a8\u09be,\u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u09ae\u09cc\u09b2\u09bf\u0995 \u0995\u09bf\u099b\u09c1 \u09ac\u09bf\u09b7\u09df \u09a8\u09bf\u09df\u09c7 \u0986\u09b2\u09cb\u099a\u09a8\u09be \u0995\u09b0\u09be \u09b9\u09df, \u09aa\u09b0\u09c7 \u09b8\u09c7\u09ac\u09bf\u09b7\u09df\u09c7 \u09ac\u09bf\u09b8\u09cd\u09a4\u09be\u09b0\u09bf\u09a4 \u0986\u09b2\u09cb\u099a\u09a8\u09be \u099a\u09b2\u09c7\u0964 \u09af\u09c7 \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8\u0997\u09c1\u09b2\u09cb\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"http:\/\/bangla.sitestree.com\/?cat=56"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5967","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=5967"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5967\/revisions"}],"predecessor-version":[{"id":5968,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5967\/revisions\/5968"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5967"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}