是否有在线工具可以构建简单的表和测试 SQL 语句?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/5670416/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 10:10:20  来源:igfitidea点击:

Is there an online tool to build simple tables and test SQL statements?

sql

提问by kertosis

I want to be able to create simple tables and run SQL queries on them. I'm talking tables with fewer than 12 items. Is there an online tool to do this? This might seem crazy, but it'd really help as I go between 3-4 computers a day.

我希望能够创建简单的表并对它们运行 SQL 查询。我说的是少于 12 个项目的表格。有没有在线工具可以做到这一点?这可能看起来很疯狂,但是当我每天在 3 到 4 台计算机之间运行时它真的很有帮助。

Example:

例子:

Cats
Cat Names | Age
Marsha    | 5
Melon     | 3

Select * from Cats where Age > 3

Marsha    | 5

Obviously that's a very, very simple example ... but I'm looking more towards testing some trickier SQL statements.

显然,这是一个非常非常简单的示例……但我更倾向于测试一些更棘手的 SQL 语句。

Edit: Not doing support. Right now I'm doing training and presentations. Screen sharing is not an option.

编辑:不做支持。现在我正在做培训和演讲。屏幕共享不是一种选择。

采纳答案by Abe Miessler

I just found this tool today:

我今天刚找到这个工具:

ideone

ideone

It lets you choose from a number of languages (including SQL), write your code and then execute it. Pretty cool

它允许您从多种语言(包括 SQL)中进行选择,编写代码然后执行它。很酷

Thanks to FreeAsInBeerfor pointing me towards it.

感谢FreeAsInBeer为我指明方向。

回答by ren

try sql fiddle- it allows you to build your own schema and supports multiple vendors.

尝试sql fiddle- 它允许您构建自己的架构并支持多个供应商。

rextestersupports Sql Server, Oracle, PostgreSQLand MySQL

rextester支持Sql ServerOraclePostgreSQLMySQL

回答by Justin Cave

If you're interested in using Oracle, you could sign up for a free workspace at http://apex.oracle.com. That is intended to give you the ability to try out Oracle's Application Express (APEX) product but the APEX development environment (all web based) does have places where you can create tables, insert data, etc. This has the nice side effect of letting you persist the data over time. And, you may find that you enjoy using APEX to build web apps as well.

如果您对使用 Oracle 感兴趣,可以在http://apex.oracle.com 上注册一个免费工作区。这旨在让您能够试用 Oracle 的 Application Express (APEX) 产品,但 APEX 开发环境(全部基于 Web)确实有可以创建表、插入数据等的地方。这有一个很好的副作用随着时间的推移,您可以保留数据。而且,您可能会发现自己也喜欢使用 APEX 构建 Web 应用程序。

See steps of creating account on Apex here

在此处查看在 Apex 上创建帐户的步骤

http://www.oraclebin.com/2013/01/how-to-execute-sql-queries-online.html

http://www.oraclebin.com/2013/01/how-to-execute-sql-queries-online.html