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 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_name	char(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!

Back to Pagehome Tutorial Page
Ordering
Support
FAQ
Suggestions
Search
Resources
Prices
Brought to you by:
Great Southern Resources, Inc.
Copyright© 1997 All rights reserved.
 
All other products mentioned are registered trademarks or trademarks of their respective companies.

Questions or problems regarding this web site should be directed to webmaster@pagehome.com.