Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Can SQL output ASCII text files?
1 Answer
- 6 years ago
Structured Query Language (SQL) is a language specification to query Relational Database Management Systems (RDBMs) often just a relational database and most people think of an RDBMS when they just say database.
It's just a way to query a database.
Thus, SQL describes what data you are searching for but not what the database server should do with it. For specific databases -- such as MySQL and Postgresql -- you can give them an SQL query (along with login credentials and the way to identify which database you want to query) and then have them output the results to standard out which you can then pipe to a file. Or you can instruct their clients to output the results to a file.
You can probably do the same with Oracle, DB2, MS SQL server.
So, technically the answer is no - it's not part of the standard. However, most database servers -- or technically clients -- have some way to output the result of an SQL query to a file, encoded in ASCII or any other relevant encoding.
