{"id":23594,"date":"2024-03-16T01:40:36","date_gmt":"2024-03-16T01:40:36","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/"},"modified":"2024-03-22T01:39:00","modified_gmt":"2024-03-22T01:39:00","slug":"how-can-i-get-the-results-of-a-sql-query-in-the-shell","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/","title":{"rendered":"How can I get the results of a SQL query in the shell?"},"content":{"rendered":"<p>In the shell, you can use command line tools to execute SQL and retrieve results. The specific command line tool depends on the database system you are using. Here are some common database systems and their corresponding command line tools:<\/p>\n<ol>\n<li>MySQL: MySQL command line tool<\/li>\n<li>PostgreSQL: psql command line tool<\/li>\n<li>The sqlplus command line tool is from Oracle.<\/li>\n<li>SQLite: sqlite3 command line tool<\/li>\n<\/ol>\n<p>When using these command line tools, you can input SQL files or SQL statements using redirection operators, and output the results to either the standard output or a file. For example, if you have saved your SQL statement in a file called query.sql, you can use the following command to execute the SQL and output the results to the standard output:<\/p>\n<pre class=\"post-pre\"><code>mysql -u username -p password -h hostname -D database &lt; query.sql\r\n<\/code><\/pre>\n<p>The -u parameter specifies the database username, the -p parameter specifies the database password, the -h parameter specifies the database hostname, and the -D parameter specifies the database name. You can modify these parameters according to the actual situation. Finally, < query.sql indicates reading SQL statements from the query.sql file.<\/p>\n<p>You can use the redirection operator &#8220;>&#8221; if you want to save the results to a file. For example:<\/p>\n<pre class=\"post-pre\"><code>mysql -u username -p password -h hostname -D database &lt; query.sql &gt; result.txt\r\n<\/code><\/pre>\n<p>This will execute the SQL and save the results to the file result.txt.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the shell, you can use command line tools to execute SQL and retrieve results. The specific command line tool depends on the database system you are using. Here are some common database systems and their corresponding command line tools: MySQL: MySQL command line tool PostgreSQL: psql command line tool The sqlplus command line tool [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-23594","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can I get the results of a SQL query in the shell? - Blog - Silicon Cloud<\/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.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can I get the results of a SQL query in the shell?\" \/>\n<meta property=\"og:description\" content=\"In the shell, you can use command line tools to execute SQL and retrieve results. The specific command line tool depends on the database system you are using. Here are some common database systems and their corresponding command line tools: MySQL: MySQL command line tool PostgreSQL: psql command line tool The sqlplus command line tool [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T01:40:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T01:39:00+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\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.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"How can I get the results of a SQL query in the shell?\",\"datePublished\":\"2024-03-16T01:40:36+00:00\",\"dateModified\":\"2024-03-22T01:39:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/\"},\"wordCount\":221,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/\",\"name\":\"How can I get the results of a SQL query in the shell? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T01:40:36+00:00\",\"dateModified\":\"2024-03-22T01:39:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can I get the results of a SQL query in the shell?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can I get the results of a SQL query in the shell? - Blog - Silicon Cloud","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.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/","og_locale":"en_US","og_type":"article","og_title":"How can I get the results of a SQL query in the shell?","og_description":"In the shell, you can use command line tools to execute SQL and retrieve results. The specific command line tool depends on the database system you are using. Here are some common database systems and their corresponding command line tools: MySQL: MySQL command line tool PostgreSQL: psql command line tool The sqlplus command line tool [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T01:40:36+00:00","article_modified_time":"2024-03-22T01:39:00+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"How can I get the results of a SQL query in the shell?","datePublished":"2024-03-16T01:40:36+00:00","dateModified":"2024-03-22T01:39:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/"},"wordCount":221,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/","name":"How can I get the results of a SQL query in the shell? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T01:40:36+00:00","dateModified":"2024-03-22T01:39:00+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-get-the-results-of-a-sql-query-in-the-shell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can I get the results of a SQL query in the shell?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=23594"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23594\/revisions"}],"predecessor-version":[{"id":57579,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23594\/revisions\/57579"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=23594"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=23594"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=23594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}