{"id":5888,"date":"2015-01-31T20:27:50","date_gmt":"2015-02-01T01:27:50","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5888"},"modified":"2015-09-03T08:17:00","modified_gmt":"2015-09-03T12:17:00","slug":"sql-update-statement","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5888","title":{"rendered":"SQL Update Statement"},"content":{"rendered":"

\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae
\nPHP Coder<\/p>\n

\u09ac\u09bf\u09b7\u09df- SQL Update Statement<\/p>\n

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 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u098f \u0995\u09cd\u09b2\u09bf\u0995 \u0995\u09b0\u09b2\u09c7 \u098f\u0995\u099f\u09bf \u09ab\u09bf\u09b2\u09cd\u09a1 \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7 \u09b8\u09c7\u0987\u0996\u09be\u09a8\u09c7 product \u09a8\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09bf\u0964 \u098f\u09b0\u09aa\u09b0 \u0993\u09aa\u09b0\u09c7\u09b0 \u09ae\u09c7\u09a8\u09c1 \u09a5\u09c7\u0995\u09c7 sql \u098f \u0995\u09cd\u09b2\u09bf\u0995 \u0995\u09b0\u09bf \u0985\u09a8\u09c7\u0995 \u09ac\u09dc \u098f\u0995\u099f\u09be textarea \u09aa\u09be\u0993\u09df\u09be \u09af\u09be\u09ac\u09c7\u0964 \u09b8\u09c7\u0987\u0996\u09be\u09a8\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 \u0995\u09cb\u09a1 \u099f\u09bf paste \u0995\u09b0\u09bf
\n— Database: `product`
\n—<\/p>\n

— ——————————————————–<\/p>\n

—
\n— Table structure for table `product`
\n—<\/p>\n

CREATE TABLE IF NOT EXISTS `product` (
\n`name` varchar(11) NOT NULL,
\n`price` int(11) NOT NULL,
\n`date` date NOT NULL,
\n`customer_id` int(250) NOT NULL
\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;<\/p>\n

—
\n— Dumping data for table `product`
\n—<\/p>\n

INSERT INTO `product` (`name`, `price`, `date`, `customer_id`) VALUES
\n(‘shirt’, 100, ‘2015-01-01’, 4),
\n(‘jeans’, 120, ‘2015-01-03’, 2),
\n(‘salowar’, 300, ‘2015-01-10’, 3),
\n(‘bag’, 150, ‘2015-01-07’, 1);
\n\u09ab\u09b2\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u09b9\u09df\u09c7 \u0997\u09c7\u09b2
\nName price date customer_id
\nBag 150 2015-01-07 1
\nShirt 100 2015-01-03 2
\nSalowar 300 2015-01-10 3
\nJeans 120 2015-01-01 4
\n\u0986\u09ae\u09a6\u09c7\u09b0 \u098f\u0987 \u099f\u09c7\u09ac\u09bf\u09b2 \u099f\u09bf\u09b0 \u09a8\u09be\u09ae product. \u09ae\u09a8\u09c7 \u0995\u09b0\u09c1\u09a8 \u0986\u09ae\u09bf name \u09ab\u09bf\u09b2\u09cd\u09a1 \u098f\u09b0 \u0986\u09a8\u09cd\u09a1\u09be\u09b0 \u09aa\u09cd\u09b0\u09a5\u09ae \u0995\u09b2\u09be\u09ae\u09c7 bag \u09a8\u09be\u09ae\u099f\u09be \u09aa\u09b0\u09bf\u09ac\u09b0\u09a4\u09a8 \u0995\u09b0\u09c7 sports bag \u09a8\u09be\u09ae\u099f\u09be \u09b2\u09bf\u0996\u09ac\u0964 \u098f\u0987 \u099c\u09a8\u09cd\u09af \u0989\u09aa\u09b0\u09c7\u09b0 \u09ae\u09c7\u09a8\u09c1 \u09a5\u09c7\u0995\u09c7 sql \u0995\u09cd\u09b2\u09bf\u0995 \u0995\u09b0\u09bf \u0995\u09cb\u09a1 \u0989\u0987\u09a8\u09cd\u09a1\u09cb \u09a4\u09c7 \u099f\u09be\u0987\u09aa \u0995\u09b0\u09bf
\nUPDATE `product`.`product` SET `name` = ‘sports bag’ WHERE `product`.`name` = ‘bag’ AND `product`.`price` =150 AND `product`.`date` = ‘2015-01-07’ AND`product`.`customer_id` =1 LIMIT 1 ;
\n\u098f\u09ac\u0982 go \u09ac\u09be\u099f\u09a8 \u098f \u0995\u09cd\u09b2\u09bf\u0995 \u0995\u09b0\u09b2\u09c7 bag \u098f\u09b0 \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09c7 sports bag \u09b9\u09df\u09c7 \u09af\u09be\u09ac\u09c7\u0964
\n\u098f\u0987
\nStatement \u099f\u09bf \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be explain \u0995\u09b0\u09bf \u09a4\u09be\u09b9\u09b2\u09c7 \u09a8\u09bf\u09ae\u09cd\u09ae\u09c7\u09b0 \u09ae\u09a4\u09a8 \u09b9\u09ac\u09c7
\nProduct database \u098f\u09b0 product table \u098f\u09b0 name \u09ab\u09bf\u09b2\u09cd\u09a1 \u098f bag \u098f\u09b0 \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09c7 sports bag \u09aa\u09b0\u09bf\u09ac\u09b0\u09a4\u09a8 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u09af\u09c7\u0996\u09be\u09a8\u09c7 price=150 \u098f\u09ac\u0982 date=2015-01-07 \u098f\u09ac\u0982 customer_id=1.\u098f\u0987\u09ad\u09be\u09ac\u09c7 \u0986\u09ae\u09b0\u09be \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u098f\u09b0 \u09af\u09c7\u0995\u09cb\u09a8\u09cb \u09ab\u09bf\u09b2\u09cd\u09a1 \u0995\u09c7 \u0986\u09aa\u09a1\u09c7\u099f \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964<\/p>\n","protected":false},"excerpt":{"rendered":"

\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 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u098f \u0995\u09cd\u09b2\u09bf\u0995 \u0995\u09b0\u09b2\u09c7 \u098f\u0995\u099f\u09bf … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[155],"tags":[],"class_list":["post-5888","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":5888,"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 "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5947,"url":"http:\/\/bangla.sitestree.com\/?p=5947","url_meta":{"origin":5888,"position":1},"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 "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5967,"url":"http:\/\/bangla.sitestree.com\/?p=5967","url_meta":{"origin":5888,"position":2},"title":"SQL Date Functions","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 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\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5963,"url":"http:\/\/bangla.sitestree.com\/?p=5963","url_meta":{"origin":5888,"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 "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6091,"url":"http:\/\/bangla.sitestree.com\/?p=6091","url_meta":{"origin":5888,"position":4},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf – \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u09b6\u09c7\u09b7 \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6\u0995\u09c3\u09a4 \u09b0\u09c7\u0995\u09b0\u09cd\u09a1 \u098f\u09b0 \u0986\u0987\u09a1\u09bf \u09ac\u09c7\u09b0 \u0995\u09b0\u09be (PHP Get ID of Last Inserted Record in Bangla)","author":"Author-Check- Article-or-Video","date":"February 21, 2015","format":false,"excerpt":"auto-increment \u09ab\u09be\u0982\u09b6\u09a8 \u098f\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be \u09af\u09cb\u0997 \u09ac\u09be \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09a8 \u0995\u09b0\u09c7 \u09a5\u09be\u0995\u09bf \u09a4\u09be\u09b9\u09b2\u09c7 \u098f\u09b0 ID \u098f\u09b0 \u09a8\u09be\u09ae\u09cd\u09ac\u09be\u09b0\u099f\u09bf \u0986\u09ae\u09b0\u09be \u0985\u09a4\u09bf \u09a6\u09cd\u09b0\u09c1\u09a4\u0987 \u09aa\u09c7\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964 Phpmyadmin \u098f \u0997\u09bf\u09df\u09c7 \"MyGuests\" \u09a8\u09be\u09ae\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09bf \u0964 \u098f\u0996\u09be\u09a8\u09c7 \u0986\u0987\u09a1\u09bf \u0995\u09b2\u09be\u09ae \u09b9\u099a\u09cd\u099b\u09c7 AUTO_INCREMENT \u09ab\u09bf\u09b2\u09cd\u09a1: CREATE TABLE MyGuests ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY\u2026","rel":"","context":"In "\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial"","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":6087,"url":"http:\/\/bangla.sitestree.com\/?p=6087","url_meta":{"origin":5888,"position":5},"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 "\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial"","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":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5888","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=5888"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5888\/revisions"}],"predecessor-version":[{"id":5889,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5888\/revisions\/5889"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5888"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}