blocks|key|4574694|text|SQL不会编译成可执行文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4574695|SQL是为从数据库中查询信息而设计的，因此为了使用它，您需要一个可以查询的DBMS。|offset|length|4574696|这种系统的一个例子可以是PostgreSQL、MySQL或SQLite。|4574697|最简单的安装方式可能是SQLite。|4574698|为了随后使用该系统，您可以打开控制台并手动执行查询，或者更有可能的是，使用您选择的编程语言中的数据库驱动程序并通过该语言执行查询，让您的程序自动处理数据。|4574699|例如，在Java语言中有JDBC，在PHP语言中有PDO，等等。|4574700|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Database_Management_System|1|http://www.postgresql.org/|2|http://mysql.com/|3|http://www.sqlite.org/|4|5|http://en.wikipedia.org/wiki/Java_Database_Connectivity|6|http://dk2.php.net/manual/en/book.pdo.php^0|0|11|4|0|0|C|A|1|N|5|2|T|6|3|0|B|6|4|0|0|C|4|5|P|3|6|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@$D|18|E|19|1|1A]]|A|$]]|$1|F|3|G|5|6|7|1B|8|@]|9|@$D|1C|E|1D|1|1E]|$D|1F|E|1G|1|1H]|$D|1I|E|1J|1|1K]]|A|$]]|$1|H|3|I|5|6|7|1L|8|@]|9|@$D|1M|E|1N|1|1O]]|A|$]]|$1|J|3|K|5|6|7|1P|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1Q|8|@]|9|@$D|1R|E|1S|1|1T]|$D|1U|E|1V|1|1W]]|A|$]]|$1|N|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]|V|$5|Q|R|S|A|$T|W]]|X|$5|Q|R|S|A|$T|Y]]|Z|$5|Q|R|S|A|$T|10]]|11|$5|Q|R|S|A|$T|10]]|12|$5|Q|R|S|A|$T|13]]|14|$5|Q|R|S|A|$T|15]]]]

SQL isn't compiled into an executable.

SQL is designed to query information from a database, so in order to use it, you need a <a href="http://en.wikipedia.org/wiki/Database_Management_System" rel="noreferrer">DBMS</a> you can query.

An example of such a system could be <a href="http://www.postgresql.org/" rel="noreferrer">PostgreSQL</a>, <a href="http://mysql.com" rel="noreferrer">MySQL</a> or <a href="http://www.sqlite.org/" rel="noreferrer">SQLite</a>.

The simplest in way of installation would probably be <a href="http://www.sqlite.org/" rel="noreferrer">SQLite</a>.

In order to then use the system, you could either open a console and do a query manually or, more likely, use a database driver in a programming language of your choice and perform a query through that, letting your program work on the data automatically.

For instance, in Java you have <a href="http://en.wikipedia.org/wiki/Java_Database_Connectivity" rel="noreferrer">JDBC</a>, in PHP you have <a href="http://dk2.php.net/manual/en/book.pdo.php" rel="noreferrer">PDO</a>, and so forth.

blocks|key|2463508|text|试试SQLite，它不需要安装，而且非常容易上手。documentation也很容易理解。你不能编译SQL，它是一种查询语言，可以被数据库理解。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2463509|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlite.org/|1|http://sqlite.org/quickstart.html^0|2|6|0|P|D|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Try <a href="http://sqlite.org/" rel="nofollow">SQLite</a>, it requires no installation and is very easy to get started with. The <a href="http://sqlite.org/quickstart.html" rel="nofollow">documentation</a> is also very easy to follow. You cannot compile SQL it is a query language and is understood by a database.

blocks|key|4574673|text|通常，您不编译sql。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4574674|它是一种命令行脚本语言|4574675|像sqlplus+for+oracle这样的工具就是接口。|4574676|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

usually you do not compile sql.

it is a command line scripting language

tools like sqlplus for oracle are the interface

blocks|key|1848486|text|通常，数据库系统有一个控制台，您可以在其中键入sql代码或命令。其中一些拥有更完善的编辑器，可以帮助您创建sql代码。这取决于您使用的数据库，但每个数据库通常都有不同的工具来输入代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1848487|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

usually the database systems have a console where you can type your sql code or commands. Some have more polished editors where it helps you to create the sql code. It depends on which database you use but each usually has different tools to enter code.

blocks|key|2463593|text|在PostgreSQL中，您可以使用命令行窗口。键入i\以及脚本文件位置和文件名，然后按enter键。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2463594|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In PostgreSQL you use a command line window. Type i\ along with the script file location and file name and then hit enter.

blocks|key|2463626|text|您不必编译SQL查询，它是在数据库管理系统(dbms)端解释的。当您将SQL语句发送到dbms时，将运行查询。出于学习目的，您可以使用联机服务来运行SQL查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2463627|有一个栈交换服务@+https://data.stackexchange.com/stackoverflow/queries，您可以在其中看到SQL查询。|offset|length|2463628|让我们来看一下SQL查询https://data.stackexchange.com/stackoverflow/query/163779。你可以看到它是纯文本的(未编译的)。|2463629|entityMap|0|LINK|mutability|MUTABLE|url|https://data.stackexchange.com/stackoverflow/queries|1|https://data.stackexchange.com/stackoverflow/query/163779^0|0|A|1G|0|0|C|1L|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

You don't have to compile SQL query, it is interpreted on the database management system (dbms) side. When you send your SQL statement to the dbms the query will be run. For learning purposes you can use online service to run SQL queries.
There is a stack exchange service @ <a href="https://data.stackexchange.com/stackoverflow/queries" rel="nofollow noreferrer">https://data.stackexchange.com/stackoverflow/queries</a> where you can see SQL queries.
Let's take a look at the SQL query <a href="https://data.stackexchange.com/stackoverflow/query/163779" rel="nofollow noreferrer">https://data.stackexchange.com/stackoverflow/query/163779</a>. You can see it is in plain text (not compiled).

blocks|key|5991770|text|这个问题并不像大多数响应者认为的那样愚蠢。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5991771|使用诸如.Net中的Linq之类的技术，需要接受SQL表达式并发出IL或其等价物的东西并不是不合理的。|offset|length|5991772|用户可配置的查询可以在运行时连接到Linq的强大功能，这将是非常有价值的。类似于Linq+To+SQL的对立面|5991773|entityMap|0|LINK|mutability|MUTABLE|url|https://en.wikipedia.org/wiki/Common_Intermediate_Language|1|https://msdn.microsoft.com/en-gb/library/bb425822.aspx^0|0|X|2|0|0|14|B|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

This question is not as daft as most responders seem to think it is.

With technologies such as Linq in .Net, it is not unreasonable to want something that takes a SQL expression and emits <a href="https://en.wikipedia.org/wiki/Common_Intermediate_Language" rel="nofollow noreferrer">IL</a> or its equivalent. 

A user-configurable query that can hook in, at runtime, to the power of Linq would be tremendously valuable. Kind of the opposite of <a href="https://msdn.microsoft.com/en-gb/library/bb425822.aspx" rel="nofollow noreferrer">Linq To SQL</a>

blocks|key|1848523|text|.我认为答案应该是Microsoft+Visual+Studio或您个人资料中的you...based版AutoCAD。AutoCAD使用VBA与SQL+Server进行本机通信。文件格式为.dvb，这是一个已编译的文件。Visual+Studio支持VB.NET，在这种情况下你不能在AutoCAD中使用VBAIDE命令来编写time....Visual应用程序。这两种语言都可以将你的SQL+Server请求编译成VB.NET文件。然后需要使用NETLOAD命令将它们加载到AutoCAD中。如果你有来自VB6.0的代码，你需要将你的模块从AutoCAD中导出出来，这样Visual+Studio就可以读取file.....in，换句话说，VS就不能读取.dvb文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1848524|VBAIDE命令将仅处理COM。它不能处理托管VB编程。|1848525|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

........ I think the answer would be Microsoft Visual Studio or AutoCAD for you...based on your profile. AutoCAD uses VBA to communicate with SQL Server natively. The file format would be .dvb and that is a compiled file. Visual Studio supports VB.NET , where you can not write .NET applications inside AutoCAD using the VBAIDE command at this time....Visual Studio allows you to write in C# or VB.NET. Both languages can compile your SQL Server requests into .dll files. You would then need to load them into AutoCAD using the NETLOAD command. If you have code from VB 6.0, you will need to export your modules out of AutoCAD so that Visual Studio can read the file.....in other words VS can not read a .dvb file.

VBAIDE command will only handle COM. It can not handle managed VB programming.

I am learning SQL but I have not been able to figure out what is used to compile and run SQL code.

How do I compile sql?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我正在学习SQL，但我还不能弄清楚用什么来编译和运行SQL代码。

问如何编译sql？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何编译sql？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何编译sql？
EN