MYSQL 處理查詢結果

. . . .
.

ALTER TABLE [user] ALTER COLUMN username ADD MASKED WITH(FUNCTION='partial(1, "xxx", 1)') 
ALTER TABLE [user] ALTER COLUMN password ADD MASKED WITH(FUNCTION='default()') 
ALTER TABLE [user] ALTER COLUMN email ADD MASKED WITH(FUNCTION='email()') 
ALTER TABLE [user] ALTER COLUMN birthday ADD MASKED WITH(FUNCTION='default()') 
ALTER TABLE [user] ALTER COLUMN phone ADD MASKED WITH(FUNCTION='partial(2, "********", 0)') 
ALTER TABLE [user] ALTER COLUMN age ADD MASKED WITH(FUNCTION='random(20, 50)')


Tags: