{"id":34583,"date":"2023-08-14T05:35:34","date_gmt":"2023-08-14T05:35:34","guid":{"rendered":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/"},"modified":"2024-07-03T06:04:16","modified_gmt":"2024-07-03T06:04:16","slug":"how-to-run-sql-queries","status":"publish","type":"knowledgebase","link":"https:\/\/www.wpstaq.com\/gb\/knowledgebase\/how-to-run-sql-queries\/","title":{"rendered":"Running SQL queries inside Staq Panel"},"content":{"rendered":"<h2><strong>Introduction<\/strong><\/h2>\n<p>Staq Panel provides a user-friendly interface to run SQL queries on your website&#8217;s database. This guide will walk you through the process of executing SQL commands directly through the Staq Panel.<\/p>\n<p><strong>Caution: Always ensure to backup your database before running any SQL queries, especially those that modify the database. Incorrect SQL commands can potentially harm your website, so proceed with caution and always double-check your queries.<\/strong><\/p>\n<h2><strong>Executing SQL Queries:<\/strong><\/h2>\n<h3><strong>Go to the site&#8217;s Staq Panel<\/strong><\/h3>\n<p>First, ensure you&#8217;re logged into your Staq Dashboard and go to the site&#8217;s Staq Panel.<\/p>\n<h3><strong>Navigate to the SQL Section<\/strong><\/h3>\n<p>Once inside Staq Panel, go to <strong>Run SQL Query<\/strong>:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/08\/run-sql-query.png\" \/><\/p>\n<h3><strong>Enter Your Query<\/strong><\/h3>\n<p>In the provided text area, type or paste the SQL query you wish to execute.<\/p>\n<h3><strong>View Database Tables<\/strong><\/h3>\n<p>If you&#8217;re unsure about the structure of your database or the tables available, click on the &#8220;click here&#8221; button. This will display a list of all available database tables, assisting you in constructing your query:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/08\/run-sql-query-view-databases.png\" \/><\/p>\n<h3><strong>Run the Query<\/strong><\/h3>\n<p>After entering your query, click on the &#8216;Execute&#8217; or &#8216;Run Query&#8217; button.<\/p>\n<h3><strong>Review Results<\/strong><\/h3>\n<p>Once the query is executed, the results (if any) will be displayed below the query input area.<\/p>\n","protected":false},"featured_media":0,"parent":0,"template":"","class_list":["post-34583","knowledgebase","type-knowledgebase","status-publish","hentry","categories-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Running SQL queries inside Staq Panel - Managed Hosting Platform for WordPress<\/title>\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.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Running SQL queries inside Staq Panel - Managed Hosting Platform for WordPress\" \/>\n<meta property=\"og:description\" content=\"Introduction Staq Panel provides a user-friendly interface to run SQL queries on your website&#8217;s database. This guide will walk you through the process of executing SQL commands directly through the Staq Panel. Caution: Always ensure to backup your database before running any SQL queries, especially those that modify the database. Incorrect SQL commands can potentially&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"Managed Hosting Platform for WordPress\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/staqhosting\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-03T06:04:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/08\/run-sql-query.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/\",\"name\":\"Running SQL queries inside Staq Panel - Managed Hosting Platform for WordPress\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/run-sql-query.png\",\"datePublished\":\"2023-08-14T05:35:34+00:00\",\"dateModified\":\"2024-07-03T06:04:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/#breadcrumb\"},\"inLanguage\":\"en-gb\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-gb\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/run-sql-query.png\",\"contentUrl\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/run-sql-query.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/knowledgebase\\\/how-to-run-sql-queries\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.wpstaq.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Running SQL queries inside Staq Panel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#website\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/\",\"name\":\"Managed Hosting Platform for WordPress\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wpstaq.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-gb\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#organization\",\"name\":\"Staq\",\"alternateName\":\"WPStaq\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-gb\",\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/cropped-LogoNoText.png\",\"contentUrl\":\"https:\\\/\\\/www.wpstaq.com\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/cropped-LogoNoText.png\",\"width\":512,\"height\":512,\"caption\":\"Staq\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wpstaq.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/staqhosting\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/wpstaq\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Running SQL queries inside Staq Panel - Managed Hosting Platform for WordPress","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.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/","og_locale":"en_US","og_type":"article","og_title":"Running SQL queries inside Staq Panel - Managed Hosting Platform for WordPress","og_description":"Introduction Staq Panel provides a user-friendly interface to run SQL queries on your website&#8217;s database. This guide will walk you through the process of executing SQL commands directly through the Staq Panel. Caution: Always ensure to backup your database before running any SQL queries, especially those that modify the database. Incorrect SQL commands can potentially&hellip;","og_url":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/","og_site_name":"Managed Hosting Platform for WordPress","article_publisher":"https:\/\/www.facebook.com\/staqhosting\/","article_modified_time":"2024-07-03T06:04:16+00:00","og_image":[{"url":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/08\/run-sql-query.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/","url":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/","name":"Running SQL queries inside Staq Panel - Managed Hosting Platform for WordPress","isPartOf":{"@id":"https:\/\/www.wpstaq.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/#primaryimage"},"image":{"@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/08\/run-sql-query.png","datePublished":"2023-08-14T05:35:34+00:00","dateModified":"2024-07-03T06:04:16+00:00","breadcrumb":{"@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/#breadcrumb"},"inLanguage":"en-gb","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/"]}]},{"@type":"ImageObject","inLanguage":"en-gb","@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/#primaryimage","url":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/08\/run-sql-query.png","contentUrl":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/08\/run-sql-query.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.wpstaq.com\/knowledgebase\/how-to-run-sql-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.wpstaq.com\/"},{"@type":"ListItem","position":2,"name":"Running SQL queries inside Staq Panel"}]},{"@type":"WebSite","@id":"https:\/\/www.wpstaq.com\/#website","url":"https:\/\/www.wpstaq.com\/","name":"Managed Hosting Platform for WordPress","description":"","publisher":{"@id":"https:\/\/www.wpstaq.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wpstaq.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-gb"},{"@type":"Organization","@id":"https:\/\/www.wpstaq.com\/#organization","name":"Staq","alternateName":"WPStaq","url":"https:\/\/www.wpstaq.com\/","logo":{"@type":"ImageObject","inLanguage":"en-gb","@id":"https:\/\/www.wpstaq.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/05\/cropped-LogoNoText.png","contentUrl":"https:\/\/www.wpstaq.com\/wp-content\/uploads\/2023\/05\/cropped-LogoNoText.png","width":512,"height":512,"caption":"Staq"},"image":{"@id":"https:\/\/www.wpstaq.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/staqhosting\/","https:\/\/www.linkedin.com\/company\/wpstaq"]}]}},"_links":{"self":[{"href":"https:\/\/www.wpstaq.com\/gb\/wp-json\/wp\/v2\/knowledgebase\/34583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wpstaq.com\/gb\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/www.wpstaq.com\/gb\/wp-json\/wp\/v2\/types\/knowledgebase"}],"wp:attachment":[{"href":"https:\/\/www.wpstaq.com\/gb\/wp-json\/wp\/v2\/media?parent=34583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}