数据脱敏实战指南:从原理到MySQL实现
CREATETABLE customers_masked ASSELECTcustomer_id,CASEWHEN gender = 'M'THEN(SELECTCONCAT(ELT(1+FLOOR(RAND*10), '张', '李', '王', '刘',
CREATETABLE customers_masked ASSELECTcustomer_id,CASEWHEN gender = 'M'THEN(SELECTCONCAT(ELT(1+FLOOR(RAND*10), '张', '李', '王', '刘',
CREATE PROCEDURE CheckNumber @InputNumber INT AS BEGIN IF @InputNumber % 2 = 0 BEGIN PRINT CONCAT(@InputNumber, ' 是偶数'); END ELSE