sqldb-rs

Rust 实现的 SQL 数据库系统，教学使用

支持的 SQL 语法

1. Create/Drop Table

create table:

CREATE TABLE table_name (
    [ column_name data_type [index] [ column_constraint [...] ] ]
    [, ... ]
   );

   where data_type is:
    - BOOLEAN(BOOL): true | false
    - FLOAT(DOUBLE)
    - INTEGER(INT)
    - STRING(TEXT, VARCHAR)

   where column_constraint is:
   [ NOT NULL | NULL | DEFAULT expr ]

drop table:

DROP TABLE table_name;

2. Insert Into

INSERT INTO table_name
[ ( column_name [, ...] ) ]
values ( expr [, ...] );

3. Select

SELECT [* | col_name | function [ [ AS ] output_name [, ...] ]]
FROM from_item
[GROUP BY col_name]
[ORDER BY col_name [asc | desc] [, ...]]
[LIMIT count]
[OFFSET count]

where function is:

• count(col_name)
• min(col_name)
• max(col_name)
• sum(col_name)
• avg(col_name)

where from_item is:

• table_name
• table_name join_type table_name [ON predicate]

where join_type is:

• cross join
• join
• left join
• right join

where on predicate is:

• column_name = column_name

4. Update

UPDATE table_name
SET column_name = expr [, ...]
[WHERE condition];

where condition is: column_name = expr

5. Delete

DELETE FROM table_name
[WHERE condition];

where condition is: column_name = expr

5. Show Table

SHOW TABLES;

SHOW TABLE `table_name`;

6. Transaction

BEGIN;

COMMIT;

ROLLBACK;

7. Explain

explain sql;