truncate table bitnami_magento.catalog_product_entity_gallery;
\ntruncate table bitnami_magento.catalog_product_entity_media_gallery_value;
\ntruncate table bitnami_magento.catalog_product_entity_media_gallery_value_to_entity;
\ntruncate table bitnami_magento.catalog_product_entity_media_gallery_value_video;<\/p>\n
no warranty
\ngiven as is<\/p>\n","protected":false},"excerpt":{"rendered":"
truncate table bitnami_magento.catalog_product_entity_gallery; truncate table bitnami_magento.catalog_product_entity_media_gallery_value; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_to_entity; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_video; no warranty given as is<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1942,182],"tags":[],"class_list":["post-68824","post","type-post","status-publish","format-standard","hentry","category-magento-2-operations-using-sql","category---blog","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":68824,"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 "\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":5961,"url":"http:\/\/bangla.sitestree.com\/?p=5961","url_meta":{"origin":68824,"position":1},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) DROP INDEX, DROP TABLE \u098f\u09ac\u0982 DROP DATABASE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f . SQL Drop Index, Drop Table & Drop Database","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) DROP INDEX, DROP TABLE \u098f\u09ac\u0982 DROP DATABASE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f Article By: Protap Chandra \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7 \u09a1\u09be\u099f\u09be \u09a7\u09b0\u09c7 \u09b0\u09be\u0996\u09be\u09b0 \u098f\u09ac\u0982 \u09a4\u09be \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0\u09c7 \u09b8\u09c1\u09ac\u09bf\u09a7\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u099f\u09c7\u09ac\u09bf\u09b2, \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8 \u0987\u09a4\u09cd\u09af\u09be\u09a6\u09bf \u09a4\u09c8\u09b0\u09c0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u0995\u09bf\u09a8\u09cd\u09a4\u09c1 \u098f\u0997\u09c1\u09b2\u09cb \u09af\u09a6\u09bf \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8 \u09a8\u09be \u09b9\u09df \u09a4\u09ac\u09c7 \u0987\u099a\u09cd\u099b\u09be \u0995\u09b0\u09b2\u09c7 \u09ae\u09c1\u099b\u09c7\u0993 \u09ab\u09c7\u09b2\u09be \u09af\u09be\u09df\u0964 \u098f\u09ae\u09a8\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u099f\u09bf\u0995\u09c7\u0993 \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8\u09c7 \u09ae\u09c1\u099b\u09c7 \u09ab\u09c7\u09b2\u09be \u09b8\u09ae\u09cd\u09ad\u09ac\u0964 \u098f\u0996\u09a8 \u0986\u09ae\u09b0\u09be \u09b6\u09bf\u0996\u09ac\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":78169,"url":"http:\/\/bangla.sitestree.com\/?p=78169","url_meta":{"origin":68824,"position":2},"title":"Some Basic SQLs in Oracle","author":"Sayed","date":"May 14, 2025","format":false,"excerpt":"-- Find Tables in a Schema -- for SH schema SELECT owner, table_nameFROM all_tableswhere OWNER = 'SH'; -- for HR Schema SELECT owner, table_nameFROM all_tableswhere OWNER = 'HR'; -- Create table based on another table DROP TABLE MyCustomer; -- Create the structure but no data create table MyCustomer AS Select\u2026","rel":"","context":"In "Root"","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":76369,"url":"http:\/\/bangla.sitestree.com\/?p=76369","url_meta":{"origin":68824,"position":3},"title":"Solution that worked for the issue: Your current session has been expired. for Magento2","author":"sayedjustetc","date":"November 17, 2024","format":false,"excerpt":"Solution that worked for the issue: Your current session has been expired. for Magento2 cat shell-scripts\/temp.sh# fix misc issues, can be routine sudo php bin\/magento maintenance:enable#sudo rm -rf var\/cache\/#sudo rm -rf generated\/sudo chmod +x bin\/magentosudo php bin\/magento setup:upgrade#sudo php bin\/magento setup:static-content:deploy -fsudo php bin\/magento setup:di:compilesudo php bin\/magento indexer:reindexsudo php bin\/magento\u2026","rel":"","context":"In "Root"","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6983,"url":"http:\/\/bangla.sitestree.com\/?p=6983","url_meta":{"origin":68824,"position":4},"title":"MongoDB Delete Document . MongoDB \u09a1\u09bf\u09b2\u09bf\u099f \u09a1\u0995\u09c1\u09ae\u09c7\u09a8\u09cd\u099f","author":"Author-Check- Article-or-Video","date":"March 6, 2015","format":false,"excerpt":"MongoDB \u09a1\u09bf\u09b2\u09bf\u099f \u09a1\u0995\u09c1\u09ae\u09c7\u09a8\u09cd\u099f \u09a8\u09df\u09a8 \u099a\u09a8\u09cd\u09a6\u09cd\u09b0 \u09a6\u09a4\u09cd\u09a4 remove() \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf MongoDB \u098f\u09b0 remove() \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf \u0995\u09be\u09b2\u09c7\u0995\u09b6\u09a8 \u09a5\u09c7\u0995\u09c7 \u09a1\u0995\u09c1\u09ae\u09c7\u09a8\u09cd\u099f \u09a1\u09bf\u09b2\u09bf\u099f \u0995\u09b0\u09a4\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u09b9\u09df\u0964 \u09a6\u09c1\u099f\u09bf \u09aa\u09cd\u09af\u09be\u09b0\u09be\u09ae\u09bf\u099f\u09be\u09b0 \u09ac\u09be\u09a6\u09c7 \u09b8\u09ac\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 remove() \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf \u0997\u09cd\u09b0\u09a3\u09af\u09cb\u0997\u09cd\u09af \u09b9\u09df\u0964 \u098f\u0995\u099f\u09bf deletion criteria \u098f\u09ac\u0982 \u0985\u09a8\u09cd\u09af\u099f\u09bf justOne flag \u0964 \u09e7\u0964 deletion criteria: (\u0985\u09aa\u09b6\u09a8\u09be\u09b2) \u09a1\u0995\u09c1\u09ae\u09c7\u09a8\u09cd\u099f \u0985\u09a8\u09c1\u09af\u09be\u09df\u09c0 deletion criteria \u09ae\u09c7\u099b\u09c7 \u09ab\u09c7\u09b2\u09be \u09b9\u09ac\u09c7\u0964 \u09e8\u0964 justOne: \u09af\u09a6\u09bf \u09b8\u09a4\u09cd\u09af\u2026","rel":"","context":"In "\u09ae\u0999\u09cd\u0997 \u09a1\u09bf \u09ac\u09bf \u0964 MongoDB"","block_context":{"text":"\u09ae\u0999\u09cd\u0997 \u09a1\u09bf \u09ac\u09bf \u0964 MongoDB","link":"http:\/\/bangla.sitestree.com\/?cat=222"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65754,"url":"http:\/\/bangla.sitestree.com\/?p=65754","url_meta":{"origin":68824,"position":5},"title":"Laravel Query Builder, Cheatsheet #Laravel","author":"Author-Check- Article-or-Video","date":"July 13, 2021","format":false,"excerpt":"$users = DB::table('users')->get() $user = DB::table('users')->where('name', 'John')->first(); $name = DB::table('users')->where('name', 'John')->pluck('name'); $roles = DB::table('roles')->lists('title'); $roles = DB::table('roles')->lists('title', 'name'); $users = DB::table('users')->select('name', 'email')->get(); $users = DB::table('users')->distinct()->get(); $users = DB::table('users')->select('name as user_name')->get(); $query = DB::table('users')->select('name'); $users = $query->addSelect('age')->get(); $users = DB::table('users')->where('votes', '>', 100)->get(); $users = DB::table('users')->where('votes', '>', 100)->orWhere('name', 'John')->get(); $users = DB::table('users')->whereBetween('votes',\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/68824","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\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=68824"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/68824\/revisions"}],"predecessor-version":[{"id":68827,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/68824\/revisions\/68827"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=68824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=68824"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=68824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}