Database - Using MCJ to Practice SQL Commands - Part 1 - Initial Startup

Using MCJ to Practice SQL Commands - Part 1 - Initial Startup

Mountain Climbing Journal (MCJ) is a journal application that includes a SQL Tool to query the database using an embedded SQLite database engine. MCJ is a single executable. In this example we are using the GNU/Linux version, but there are versions for Microsoft Windows and Mac OS X as well:

[usr-1@sv-1 sqlart]$ ls
mcjl
[usr-1@sv-1 sqlart]$

When the application is first launched it looks for an mcj.rsd database file. If none is found, it creates one:

Here is what the application looks like running:

Here you can see the mcj.rsd database:

[usr-1@sv-1 sqlart]$ ls -l
total 11692
-rwxr-xr-x  1 usr-1 usr-1 11939695 Nov 18 14:04 mcjl
-rw-r--r--  1 usr-1 usr-1    13312 Nov 18 14:09 mcj.rsd
[usr-1@sv-1 sqlart]$ i

Part 1 | Part 2 | Part 3 | Next

This article comes from NetAdminTools:
http://www.netadmintools.com/

The URL for this story is:
http://www.netadmintools.com/art568.html

Copyright 1997-2008 NetAdminTools.com. Read our Terms of Use.