{"id":1842,"date":"2012-10-05T13:50:38","date_gmt":"2012-10-05T13:50:38","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/10\/05\/delete-custom-query\/"},"modified":"2021-08-16T23:34:17","modified_gmt":"2021-08-17T03:34:17","slug":"delete-custom-query","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/","title":{"rendered":"How to delete a custom SQL Query in PrestaShop 1.5"},"content":{"rendered":"

Our last aritcle explained how to export your custom query results in a CSV file and save it to your computer. This next article in the Working with SQL Manager course quickly shows you how to remove a query from the list. Once you no longer need a custom query,\u00a0 you may want to delete it from the list to save space or reduce clutter within your PrestaShop store. The instructions below will show you how to do just that.<\/p>\n

Exporting custom SQL query results in PrestaShop 1.5<\/strong><\/p>\n

    \n
  1. Log into your PrestaShop 1.5 dashboard<\/a>.<\/li>\n
  2. Using the top menu bar, hover over the Advanced Parameters<\/strong> tab and click on the SQL Manager<\/strong> option from the menu.<\/li>\n
  3. This brings you to the SQL Manager<\/em> page where you will find all of your custom queries listed. From here there are two ways to remove a query from the list. The first way is to click on the checkbox to the left side of the custom SQL query you want to delete, you can select more than one query by doing this if you wish. Once you have selected your items, click the Delete Selected<\/strong> button underneath the list.\n

    The second way is to click the Delete<\/strong> icon that looks like a trashcan on the right side of the respective row for the query you want to remove. <\/p>\n

    No matter which method you choose, you will be met with a confirmation pop-up window. Select the OK<\/strong> button to confirm the deletion.
    \"delete-file\"<\/a><\/p>\n

  4. After confirming the deletion, the database backup will be deleted and the screen will refresh. You will see that the selected database backup will have been removed from the list.
    \"delete-after\"<\/a>\n
    <\/div>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Our last aritcle explained how to export your custom query results in a CSV file and save it to your computer. This next article in the Working with SQL Manager course quickly shows you how to remove a query from the list. Once you no longer need a custom query,\u00a0 you may want to delete Read More ><\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[92,4305],"tags":[],"class_list":["post-1842","post","type-post","status-publish","format-standard","hentry","category-prestashop","category-databases"],"acf":[],"yoast_head":"\nHow to delete a custom SQL Query in PrestaShop 1.5 | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"This PrestaShop 1.5 tutorial walks you through deleting a custom SQL query.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to delete a custom SQL Query in PrestaShop 1.5 | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"This PrestaShop 1.5 tutorial walks you through deleting a custom SQL query.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-05T13:50:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:34:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to delete a custom SQL Query in PrestaShop 1.5\",\"datePublished\":\"2012-10-05T13:50:38+00:00\",\"dateModified\":\"2021-08-17T03:34:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/\"},\"wordCount\":284,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png\",\"articleSection\":[\"Prestashop\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/\",\"name\":\"How to delete a custom SQL Query in PrestaShop 1.5 | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png\",\"datePublished\":\"2012-10-05T13:50:38+00:00\",\"dateModified\":\"2021-08-17T03:34:17+00:00\",\"description\":\"This PrestaShop 1.5 tutorial walks you through deleting a custom SQL query.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png\",\"width\":1040,\"height\":258,\"caption\":\"delete-file\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to delete a custom SQL Query in PrestaShop 1.5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to delete a custom SQL Query in PrestaShop 1.5 | InMotion Hosting","description":"This PrestaShop 1.5 tutorial walks you through deleting a custom SQL query.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/","og_locale":"en_US","og_type":"article","og_title":"How to delete a custom SQL Query in PrestaShop 1.5 | InMotion Hosting","og_description":"This PrestaShop 1.5 tutorial walks you through deleting a custom SQL query.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-10-05T13:50:38+00:00","article_modified_time":"2021-08-17T03:34:17+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to delete a custom SQL Query in PrestaShop 1.5","datePublished":"2012-10-05T13:50:38+00:00","dateModified":"2021-08-17T03:34:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/"},"wordCount":284,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png","articleSection":["Prestashop","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/","name":"How to delete a custom SQL Query in PrestaShop 1.5 | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png","datePublished":"2012-10-05T13:50:38+00:00","dateModified":"2021-08-17T03:34:17+00:00","description":"This PrestaShop 1.5 tutorial walks you through deleting a custom SQL query.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_SQL_Manager_Delete_delete-file.png","width":1040,"height":258,"caption":"delete-file"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/delete-custom-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to delete a custom SQL Query in PrestaShop 1.5"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=1842"}],"version-history":[{"count":2,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1842\/revisions"}],"predecessor-version":[{"id":85541,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1842\/revisions\/85541"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=1842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=1842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=1842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}