摘要:
UPDATE tb_track_scale_record SET trainWeight = ( CASE WHEN grossWeight IS NOT NULL THEN tareWeight WHEN tareWeight IS NOT NULL THEN tareWeight END ); 阅读全文
摘要:
setSqlSelect 设置 SELECT 查询字段 where WHERE 语句,拼接 + WHERE 条件 and AND 语句,拼接 + AND 字段=值 andNew AND 语句,拼接 + AND (字段=值) or OR 语句,拼接 + OR 字段=值 orNew OR 语句,拼接 + 阅读全文
摘要:
mysql> insert into DemoTable834 values(10,20); mysql> insert into DemoTable834 values(40,50); mysql> insert into DemoTable834 values(20,24); mysql> in 阅读全文