sql更新一条记录的语句

2024-12-27 12:45:39
推荐回答(3个)
回答1:

ID是字符型:
update tbpd_pdrz set f_jzrbm='', f_jzrxm='', f_jzsj_jzbz='' where id = '2'

ID是数值型:
update tbpd_pdrz set f_jzrbm='', f_jzrxm='', f_jzsj_jzbz='' where id = 2

回答2:

update tbpd_pdrz set f_jzrbm="", f_jzrxm="", f_jzsj _jzbz="" where id = 2

回答3:

delete from tbpd_pdrz where id=2