|
mSQL Tutorial
Introduction
"mSQL is a lightweight database engine designed to provide fast access to stored
data with low memory requirements." - mSQL Manual
Now you know what mSQL is, let's start working with it. At the telnet
command prompt type msql [database] where "database" is the name of your
database. You will get the following prompt:
Welcome to the mSQL
monitor. Type \h for help.
mSQL>
|
And if you type \h you'll get the following:
MiniSQL Help!
The following commands are available:-
\q Quit
\g Go (Send query to database)
\e Edit (Edit previous query)
\p Print (Print the query buffer)
mSQL>
|
Whenever you do anything in mSQL you just type it and on a line by itself type \g
to send it. If what you type is incorrect mSQL will let you know and allow you to go fix
it by typing \e.
The following is a sample session:
Welcome to the mSQL
Monitor. Type \h for help.
mSQL> CREATE TABLE test (
-> first_namechar(15) not null,
-> emp_id int primary key
-> )
-> \g
Query OK.
mSQL>
|
It is not necessary to type the commands in uppercase.
So now that you know the basics of working with mSQL let's move
on to lesson 1!
|
