{"id":6868,"date":"2019-12-06T10:33:31","date_gmt":"2019-12-06T10:33:31","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=6868"},"modified":"2022-02-12T13:03:56","modified_gmt":"2022-02-12T13:03:56","slug":"how-can-i-run-sql-queries-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/","title":{"rendered":"How can I run SQL queries in phpMyAdmin?"},"content":{"rendered":"<p>The article will guide you on how to run SQL queries in phpMyAdmin.<\/p>\n<p>SQL queries are executed in commands that are issued to the MySQL server to perform various functions. SQL is mostly used by developers to make changes to your database by using appropriate commands.<\/p>\n<p>To execute MySQL query for a database, open the database with phpMyAdmin and then click on the SQL tab.<\/p>\n<p>Perform the following steps to run SQL queries in phpMyAdmin :<\/p>\n<p>1) Login to<strong> cPanel<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13347\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg\" alt=\"cPanel myadmin\" width=\"966\" height=\"198\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg 966w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1-300x61.jpg 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1-768x157.jpg 768w\" sizes=\"auto, (max-width: 966px) 100vw, 966px\" \/><\/a><\/p>\n<p>2) Go to <strong>Software<\/strong> and then click on <strong>phpMyAdmin<\/strong>.<\/p>\n<p>3) Navigate to the area, where your SQL query appears. Select the database or tables for which you want to run queries.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-screen.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13348\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-screen.jpg\" alt=\"SQL screen\" width=\"679\" height=\"431\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-screen.jpg 679w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-screen-300x190.jpg 300w\" sizes=\"auto, (max-width: 679px) 100vw, 679px\" \/><\/a><\/p>\n<p>4) Click the <strong>SQL<\/strong> tab.<\/p>\n<p>5) Now type your SQL query here.<\/p>\n<p>6) Click on <strong>Go<\/strong>. Your query will get executed.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-execute.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13349\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-execute.jpg\" alt=\"SQL query execute\" width=\"1122\" height=\"420\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-execute.jpg 1122w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-execute-300x112.jpg 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-execute-1024x383.jpg 1024w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-execute-768x287.jpg 768w\" sizes=\"auto, (max-width: 1122px) 100vw, 1122px\" \/><\/a><\/p>\n<p>The result from a query that we executed is :<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-results.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13350\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-results.jpg\" alt=\"SQL query results\" width=\"1130\" height=\"367\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-results.jpg 1130w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-results-300x97.jpg 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-results-1024x333.jpg 1024w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/SQL-query-results-768x249.jpg 768w\" sizes=\"auto, (max-width: 1130px) 100vw, 1130px\" \/><\/a><\/p>\n<p>Once the SQL query has fired and executed, the command screen confirms that your SQL query has been executed successfully.<\/p>\n<p><strong>Also Read :<\/strong><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-to-sqlite-using-php\/\" target=\"_blank\" rel=\"noopener\"><strong> How can I connect to SQLite using PHP?<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-mysql-tables-in-phpmyadmin\/\" target=\"_blank\" rel=\"noopener\"><strong> How To Create MySQL Tables In phpMyAdmin?<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-search-mysql-tables-in-phpmyadmin\/\" target=\"_blank\" rel=\"noopener\"><strong> How to search MySQL tables in phpMyAdmin?<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The article will guide you on how to run SQL queries in phpMyAdmin. SQL queries are executed in commands that are issued to the MySQL server to perform various functions. SQL is mostly used by developers to make changes to your database by using appropriate commands. To execute MySQL query for a database, open the [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[616,979,1127,1126],"class_list":["post-6868","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","tag-phpmyadmin","tag-sql","tag-sql-queries-in-phpmyadmin","tag-sql-query"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can I run SQL queries in phpMyAdmin? - Web Hosting FAQs by MilesWeb<\/title>\n<meta name=\"description\" content=\"A simple guide to run SQL queries in phpMyadmin.\" \/>\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.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can I run SQL queries in phpMyAdmin? - Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"og:description\" content=\"A simple guide to run SQL queries in phpMyadmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-06T10:33:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-12T13:03:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg\" \/>\n<meta name=\"author\" content=\"Sonam Wagh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sonam Wagh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/\",\"name\":\"How can I run SQL queries in phpMyAdmin? - Web Hosting FAQs by MilesWeb\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg\",\"datePublished\":\"2019-12-06T10:33:31+00:00\",\"dateModified\":\"2022-02-12T13:03:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\"},\"description\":\"A simple guide to run SQL queries in phpMyadmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg\",\"width\":966,\"height\":198,\"caption\":\"cPanel myadmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can I run SQL queries in phpMyAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\",\"name\":\"Sonam Wagh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"caption\":\"Sonam Wagh\"},\"description\":\"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How can I run SQL queries in phpMyAdmin? - Web Hosting FAQs by MilesWeb","description":"A simple guide to run SQL queries in phpMyadmin.","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.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How can I run SQL queries in phpMyAdmin? - Web Hosting FAQs by MilesWeb","og_description":"A simple guide to run SQL queries in phpMyadmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-12-06T10:33:31+00:00","article_modified_time":"2022-02-12T13:03:56+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg","type":"","width":"","height":""}],"author":"Sonam Wagh","twitter_misc":{"Written by":"Sonam Wagh","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/","name":"How can I run SQL queries in phpMyAdmin? - Web Hosting FAQs by MilesWeb","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg","datePublished":"2019-12-06T10:33:31+00:00","dateModified":"2022-02-12T13:03:56+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4"},"description":"A simple guide to run SQL queries in phpMyadmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-myadmin-1.jpg","width":966,"height":198,"caption":"cPanel myadmin"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How can I run SQL queries in phpMyAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4","name":"Sonam Wagh","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","caption":"Sonam Wagh"},"description":"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/"}]}},"views":564,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=6868"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6868\/revisions"}],"predecessor-version":[{"id":13351,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6868\/revisions\/13351"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=6868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=6868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=6868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}