SELECT SUBSTRING(CAST(pol_relevance_id AS VARCHAR), 0, 4)
FROM PRODUCT_OPERATE_LOG
设置某个字段的值为另一个字段的前3位!
UPDATE PRODUCT_OPERATE_LOG
SET pol_pdid = SUBSTRING(CAST(pol_relevance_id AS VARCHAR), 0, 4)
SELECT SUBSTRING(CAST(pol_relevance_id AS VARCHAR), 0, 4)
FROM PRODUCT_OPERATE_LOG
设置某个字段的值为另一个字段的前3位!
UPDATE PRODUCT_OPERATE_LOG
SET pol_pdid = SUBSTRING(CAST(pol_relevance_id AS VARCHAR), 0, 4)