Sun. Sep 20th, 2026

判断workcode列不是数字,udpate 为空

判断workcode列不是数字,udpate 为空
update tableName set workcode = null where workcode like ‘%[^0-9]%’

By kim

Leave a Reply