在哪里可以运行 SQL?
我正在学习SOLOLEARN上的SQL,我想知道我可以在哪里运行SQL? VSC是否可以让您运行SQL,并且需要验证才能这样做吗?我已经安装XAMPP,因此,如果XAMPP帮助任何知识会有所帮助。 我仍然是Stackoverflow的新手,所以很抱歉错误的问题和类似的问题。 谢谢你!
I'm learning SQL on sololearn, and I want to know where I can run SQL?
Does VSC let you run SQL and does it need validation to do so? I have Xampp Installed so if Xampp helps any knowledge would help.
I'm still new to stackoverflow so sorry for wrong questions and stuff like that.
Thank you!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这是我经验的一些指示。
bigquery
您将需要一个Google帐户并设置帐单资料,但在试用期间不会收取费用,这是一个非常慷慨的试验,我在工作中使用了3个月,而无需支付一毛钱。您可以访问和播放很多免费的公共数据集,并且如果您有自己的数据,可以通过CSV或Google表可以轻松导入数据,以及其他一些方法。
StratasCratch
当学习SQL时,这个网站在学习SQL时会极大地帮助我,一旦您学习了SQL的基础知识,就绝对出色。该网站提供了很多问题,您必须依靠SQL来查询提供的数据集。这一切都是很棒的,因此无需下载软件或导入数据,只需单击一个问题即可!您还可以看到其他用户提交给问题的提交,因此您可以学习更有效的方法来解决答案。
mysql
最初需要一些设置(无论如何与BigQuery相比),但是一旦完成,您就可以将其用作与SQL相关的所有事物的操场。更多详细信息在这里。
要使VSC作为SQL的接口工作,您需要将VSC连接到SQL Server。我自己没有做这个,但更多详细信息在这里。
希望这有帮助!
汤姆
Here's a few pointers from my experience.
BigQuery
You'll need a google account and to setup a billing profile but you won't be charged during the trial, and it's a pretty generous trial in my opinion and I used it at work for 3 solid months without paying a dime. There're plenty of free public datasets you can access and play around with, and you can easily import data via CSV or google sheets and a few other methods if you have your own data you want to practice on.
StrataScratch
This site helped me tremendously when learning SQL, and absolutely fantastic once you've learned the basics of SQL. The site provides plenty of questions you must answer relying on SQL to query the datasets provided. This is all possible on the site which is great, so no need to download software or import data, just click a question and go! You can also see other users submissions to the question so you can learn perhaps more efficient ways of getting to the answer.
MySQL
Takes a bit of setup initially (compared to bigquery anyway), but once you're done you can use this as your playground for all things SQL related. More Details here.
For VSC to work as your interface for SQL, you need to connect VSC to a SQL server. I've not done this myself but more details here.
Hope this helps!
Tom