新增字段格式:
ALTER TABLE 表名 ADD 字段名称 字段类型(字段长短-选填) CHARACTER SET utf8mb4 COLLATE
utf8mb4_general_ci NOT NULL(是否不可为空) DEFAULT 0(默认值) COMMENT '备注' ;
eg:
ALTER TABLE table_name ADD COLUMN age varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT '年龄' ;
mysql 根据逗号对字段分割计算字段的长度:
EXPLAIN UPDATE ncs_fx_frandcategory
SET WEIGHT = 30
WHERE
id IN (
SELECT
id
FROM
(
SELECT
id
FROM
ncs_fx_frandcategory
WHERE
TOPIC_CLASS LIKE '1%'
AND ( LENGTH( WORD ) - LENGTH( REPLACE ( WORD, ',', '' )) + 1 ) <= 1
) AS t1
)