# mylex

**Repository Path**: wkc/mylex

## Basic Information

- **Project Name**: mylex
- **Description**: 编译原理  学习
- **Primary Language**: Python
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2014-05-01
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

语法支持:
只支持一个数据库

    CREATE TABLE db_test ( first_col INTERGER,second_col VARCHAR, PRIMARY KEY(first_col) )
    DELETE FROM db_test
    SELECT * FROM db_test ORDER BY first_col DESC
    SELECT COUNT(*) FROM db_test
    SELECT 'Monty!' REGEXP '.*';
    SELECT 'Monty!' LIKE '.*';
    INSERT INTO db_test VALUES(43,54,"4535")
    ALTER TABLE db_test RENAME TO  db_test2
    COPY TABLE db_test TO db_test2
    DROP TABLE db_test
    SHOW TABLES
    SAVE 'a.json' TO 'db_test'
    LOAD 'a.json' TO 'db_test'

函数 

    ARG()
    COUNT()
    MAX()
    MIN()
    SUM()
    ABS()
    LENGTH()
    TYPEOF()

数据类型

    INT
    INTERGER
    REAL
    VARCHAR


表达式

    + = * /  % 
    IS NOT IN LIKE AND OR