SQL常用语句

获取最大值

SELECT MAX(DefenseDamage) AS MaxDefenseDamage FROM NpcParams;

查询字段中不重复的值

SELECT DISTINCT {字段名} FROM {表名};
SELECT DISTINCT AttackType FROM NpcParams;

更新指定的列

SELECT Type

UPDATE <表名> SET 字段 1=值 1 [,字段 2=值 2… ] [WHERE 子句 ]
 
[ORDER BY 子句] [LIMIT 子句]