If you have installed msql-2 on your system then you can have a look at the sample programs written in Lite, msql-2's own scripting language.
Either version of msql comes with a basic set of administration
tools which allow the user to create and drop tables
(msqladmin
) and examine database structures (relshow
).
The second generation msql (i.e. msql-2) has a few more genuinely
useful utilities: msqlimport
and msqlexport
. These allow
the dumping of flat line data files into and out of the SQL
database. They can be used for loading quantities of existing data
d'un coup into existing tables, or extract flat data from
tables, and the user does not have to deal with writing a
single line of perl or SQL or whatever code for this task.
If you want to write your own perl scripts dealing with databases you'll find sufficient support in the example files and the extensive on-line documentation that comes with the DBI module.
Anyway, you are now ready to go and present your data to the users of your own network, or even the WWW.