当一个表(一般为中间表)为复合主键时,在主键不冲突的前提下,可修改主键的值
eg:update sys_festposttype SET type = '99',typename = NULL where fid = '01' and fpid = '1' and type = '98'
表结构如下:
当一个表(一般为中间表)为复合主键时,在主键不冲突的前提下,可修改主键的值
eg:update sys_festposttype SET type = '99',typename = NULL where fid = '01' and fpid = '1' and type = '98'
表结构如下: