Your own SQL Server plus the client

The SQL Server itself is made up of client-side, with syntax parsing and simple database operation (no database APIs using MFC). The interface uses the Cj60lib class library, and the syntax display uses the Crystaledit class.

Login account: Aministrator:admin admin, you can add accounts and change account types.

Super User:superuser Superuser, you can perform all the operations.

User:user user, you can only perform query functions.

Simple Feature Introduction:

I. Data definition DDL (data definition Language)

1, build the form:

CREATE TABLE table_name(
　　　column1 DATATYPE ,
　　　column2 DATATYPE ,
　　　...);

Description: DATATYPE--is the format of the data, including:

int 4 BYTES
　　　long 4 BYTES
　　　float 8 BYTES
　　　date
　　　char( NUM ) NUM ：数目，用户定义

2, establish the index:

CREATE INDEX index_name ON table_name (column_name);

Description: Index The field of a table to increase the speed of the query.

3, delete the form:

DROP TABLE table_name;

4. Delete index:

DROP INDEX index_name;

Ii. Data manipulation DML (data manipulation Language)

1. Additional Information:

INSERT INTO table_name (column1,column2,...)
　　　VALUES ( value1,value2, ...);

Description

1. If no column system is specified, the information will be filled in the order of the fields in the table.

2. The data form of the field and the information to be filled must match.