# HiSQL

**Repository Path**: power/HiSQL

## Basic Information

- **Project Name**: HiSQL
- **Description**: A Java project to learn SQL syntax(MySQL).
- **Primary Language**: Java
- **License**: LGPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2016-10-19
- **Last Updated**: 2023-09-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#HiSQL
A Java project to learn SQL syntax(MySQL).
```
    @Test
    public void test() {
        String sql = query
            .distinct()
            .addColumn("id")
            .addColumn("name")
            .addColumn("MAX(age)", "age")
            .from("clients")
            .where("id", "=", "1001")
            .or("age > 18")
            .groupBy("age")
            .orderBy("name", Order.ASC)
            .orderBy("age", Order.DESC)
            .orderBy("id")
            .limit(10, 5)
            .toSql();

        assertEquals("SELECT DISTINCT id, name, MAX(age) AS age FROM clients WHERE id = 1001 OR (age > 18) "
                         + "GROUP BY age ORDER BY name ASC, age DESC, id LIMIT 10, 5", sql);
    }
```