Featured image of post MYSQL 處理查詢結果

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)')

 

Licensed under CC BY-NC-SA 4.0