{"id":445,"date":"2017-02-19T14:32:10","date_gmt":"2017-02-19T14:32:10","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&#038;p=445"},"modified":"2020-08-05T17:58:33","modified_gmt":"2020-08-05T17:58:33","slug":"running-sql-queries-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/running-sql-queries-phpmyadmin\/","title":{"rendered":"Running SQL Queries with phpMyAdmin"},"content":{"rendered":"<p>In this tutorial, we&#8217;ll show you how to run SQL Queries with phpMyAdmin. We&#8217;ll assume that you are already logged into phpMyAdmin If you are not logged in just follow the steps in <a href=\"https:\/\/chemicloud.com\/kb\/article\/how-to-use-phpmyadmin\/\" target=\"_blank\" rel=\"noopener noreferrer\">this tutorial<\/a> to login.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>1)<\/strong> Click the database table you wish to run a SQL query on. In this example, we&#8217;ll use chemiclo_demo.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" style=\"height: 135px; width: 720px;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/phpmyadmin_sql_queries.png\" alt=\"phpmyadmin sql queries\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>2)<\/strong> Click on the <strong>SQL<\/strong> tab.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" style=\"height: 126px; width: 720px;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/phpmyadmin_sql_queries1.png\" alt=\"phpmyadmin sql queries\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>3)<\/strong> Enter the entire SQL query code and click &#8220;<strong>Go&#8221;<\/strong> when finished to execute. You&#8217;ll see a confirmation message if the\u00a0query ran successfully\u00a0or an error message if there was something wrong with your query.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" style=\"height: 219px; width: 720px;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/phpmyadmin_sql_queries_command%281%29.png\" alt=\"\" \/><\/p>\n<p>&nbsp;<\/p>\n[mkb-info]You can find more information about how to run SQL queries if you click on the question mark, this will take you to the official MySQL website.[\/mkb-info]\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" style=\"height: 126px; width: 720px;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/phpmyadmin_sql_queries_more.png\" alt=\"phpmyadmin sql queries\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we&#8217;ll show you how to run SQL Queries with phpMyAdmin. We&#8217;ll assume that you are already logged into phpMyAdmin If you are not logged in just follow the steps in this tutorial to login. &nbsp; 1) Click the database table you wish to run a SQL query&#8230;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[124,125],"class_list":["post-445","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql","ht_kb_tag-phpmyadmin","ht_kb_tag-sql"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=445"}],"version-history":[{"count":2,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/445\/revisions"}],"predecessor-version":[{"id":3195,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/445\/revisions\/3195"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=445"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=445"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}