Hi all,
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 office computer and I want to practice queries in my free time.
views:
31answers:
2
A:
[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.
Marcelo Cantos
2010-07-17 11:33:27
Yes, I am using Windows. But, I don't want to install any dbms.
Himadri
2010-07-17 12:00:41
@Himadri: sqlite3.exe is a completely self-contained program that provides a convenient database command-line. It is literally a single file that you can just copy onto your computer and run, without any installation process. See [here](http://www.sqlite.org/sqlite.html) for more information and a quick tutorial. It will take you five minutes to download it, run it, and decide for yourself whether it does what you want.
Marcelo Cantos
2010-07-17 12:16:22
A:
There is one online query execution tool provided by w3cshcools
I got this answer after asking a question in this forum.
Himadri
2010-08-11 03:59:57