hou_jibofa的博客

mysql 5.8版本的排序函数ROW_NUMBER() OVER , RANK() , DENSE_RANK()测试表CREATE TABLE record_table (id int(0) NOT NULL AUTO_INCREMENT,record int(0) NULL DEFAULT 0,age varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,username varchar(255

update 表名 set belongSysCode = 'DSJJQ' where useFor = '大数据集群' and belongSysCode ='' OR belongSysCode = '';上边的语句执行不会报错,但是也没有成功将 where 条件中的改为:belongSysCode is null,执行成功update assets_host set belongSysCode = ‘DSJJQ’ where useFor = ‘大数据集群’ and belongSysCod