I wanted to know if there is any system which allow me to create my own tables and execute query on those tables? I want these because I don't have any database installed on my o开发者_如何学JAVAffice computer and I want to practice queries in my free time.
There is one online query execution tool provided by w3cshcools
I got this answer after asking a question in this forum.
[The following answer largely assumes you are using Windows.]
For a very quick-n-dirty sandbox, try SQLite. It comes with sqlite3.exe (see the Precompiled Binaries For Windows section), which lets you create tables and run queries over them from the command-line.
SQLite's dialect of SQL is a bit strange due to its dynamic typing model, so you might get more mileage from installing a more conventional database like PostgreSQL, though it is more involved than SQLite's "installation", which amounts to extracting the .exe file and sticking it somewhere on your path.
精彩评论