package org.example.join.util;

public interface SqlConstant {

    String SQL_PARAM = "joinSqlParam";

    String SELECT = "select ";
    String FROM = " from ";
    String WHERE = " where ";

    String INNER_JOIN = " inner join ";
    String LEFT_JOIN = " left join ";
    String RIGHT_JOIN = " right join ";

    String GROUP_BY = " group by ";
    String ORDER_BY = " order by ";

    String LIMIT = " limit ";

    String UNION = " union ";
    String UNION_ALL = " union all ";

    String AND = " and ";
    String OR = " or ";

    String ON = " on ";

    String ADD = " + ";
    String SUBTRACT = " - ";
    String MULTIPLY = " * ";
    String DIVIDE = " / ";
    String REMAINDER = " % ";

    String ASC = " asc";
    String DESC = " desc";

    String EQ = " = ";
    String NE = " <> ";
    String GT = " > ";
    String LT = " < ";
    String GE = " >= ";
    String LE = " <= ";
    String BETWEEN = " between ";
    String NOT_BETWEEN = " not between ";
    String LIKE = " like ";
    String NOT_LIKE = " not like ";
    String LIKE_LEFT = " like left ";
    String NOT_LIKE_LEFT = " not like left ";
    String LIKE_RIGHT = " like right ";
    String NOT_LIKE_RIGHT = " not like right ";
    String IS_NULL = " is null";
    String IS_NOT_NULL = " is not null";
    String IN = " in ";
    String NOT_IN = " not in ";

    /**
     * 函数关键字
     */
    String ABS = "ABS";
    String AVG = "AVG";
    String COUNT = "COUNT";
    String CONCAT = "CONCAT";
    String DATEDIFF = "DATEDIFF";
    String DATE_FORMAT = "DATE_FORMAT";
    String IF = "IF";
    String IFNULL = "IFNULL";
    String MAX = "MAX";
    String MIN = "MIN";
    String NOW = "NOW";
    String REPLACE = "REPLACE";
    String ROUND = "ROUND";
    String SUBSTR = "SUBSTR";
    String LENGTH = "LENGTH";
    String YEAR = "YEAR";
    String MONTH = "MONTH";
    String DAY = "DAY";
    String HOUR = "HOUR";

}