MSQL database design technology in Linux _ MySQL

In Linux, mSQL database design technology mSQL (mini SQL) is a single-user database management system. because of its short precision, its developed application systems are particularly favored by Internet users. I have developed a Web-based management system in Linux, which uses the mSQL database for data management. The system works well in actual operation. After summary, I will introduce the mSQL database development methods in Linux in detail.

First, you can download the latest version of the software free of charge after registering at www.hughes.com. au. The installation of mSQL is quite simple. the binary version (for software compiled on a hardware platform) is to expand the file to a user's directory and configure several parameters. For example, the file you downloaded is: mSQL-2.0.3.tar.gz, you want to install mSQL to the/usr/local directory, then we need to copy this file to the/usr/local directory, then type the command tar zxvf mSQL-2.0.3.tar.gz, which expands the compressed file. Generally, all files in the mSQL database system are installed in the/usr/local/Hughes directory. Configure the mSQL database. All you need to do is modify the file msql. conf in the/usr/local/Hughes directory.

In actual applications, the mSQL-User and Admin-User parameters are the most modified. MSQL-User indicates the User who runs the mSQL database service program, and Admin-User indicates that the User can perform privileged operations on the mSQL database system (for example, closing the running of the database service program and creating a database). Therefore, if you want the mSQL service program to run as a database User and specify the admin User to perform database operations, you need to change the rows of mSQL-User and Admin-User: mSQL-User = database and Admin-User = admin. In addition, you must change the owner of the files and directories under the Hughes directory to the database. After the configuration is complete, unregister the identity of the current user and re-use msql. the conf parameter mSQL-User-defined User logs on to the system and enters the/usr/local/Hughes/bin directory. enter the following command :. /msql2d &, then the mSQL database system is started. For the installation software with source code, you can check the README and INSTALL files to complete the installation.

To integrate mSQL into your applications, the mSQL database system provides you with a C language API library and an interpreter: w3-msql, which uses the C language API library, you can integrate mSQL into applications developed in standard C language. With the w3-msql tool, you can embed the mSQL database into an HTML file by writing C-language scripts. The following is an example of a program.

The following program snippet is used to compare the user name and password submitted on the browser page with the user name and password in the registered table. if the user name and password are correct, the successful registration information is displayed on the page. Otherwise, the user registration fails. The method implemented in C language is as follows:

Void main (int argc, char