这样就好了,呵呵!UPDATE test SET
fanum = LEFT( CONCAT( '003001001', RIGHT( num, (
LENGTH( num ) -6 ) ) ) ,
(
LENGTH( CONCAT( '003001001', RIGHT( num, (
LENGTH( num ) -6 ) ) )
) -3
)
),
num = CONCAT( '003001001', RIGHT( num, LENGTH( num ) -6 ) )
WHERE LEFT( fanum, 6 ) = '003003'
fanum = LEFT( CONCAT( '003001001', RIGHT( num, (
LENGTH( num ) -6 ) ) ) ,
(
LENGTH( CONCAT( '003001001', RIGHT( num, (
LENGTH( num ) -6 ) ) )
) -3
)
),
num = CONCAT( '003001001', RIGHT( num, LENGTH( num ) -6 ) )
WHERE LEFT( fanum, 6 ) = '003003'
fanum = LEFT( num ) ,
(
LENGTH( num )
) -3
)
) WHERE LEFT( fanum, 6 ) = '003003'
我是这样理解的..