Wed. Jul 22nd, 2026

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

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

By kim

Leave a Reply