15,030
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
m
→case1: 王小明 --> 王OO
| Line 16: | Line 16: | ||
* MySQL: | * MySQL: | ||
<pre> | <pre> | ||
-- SET @name := "楊過"; | -- SET @name := "楊過"; | ||
SET @name := "王小明"; | SET @name := "王小明"; | ||
-- SET @name := "孤獨求敗"; | -- SET @name := "孤獨求敗"; | ||
-- SET @name := "Guo da-xia"; | -- SET @name := "Guo da-xia"; | ||
SELECT CONCAT(LEFT(@name, 1), 'OO'); | SELECT CONCAT(LEFT(@name, 1), 'OO'); | ||
/* result: | |||
* 楊過 -> 楊OO | |||
* 王小明 --> 王OO | |||
* 孤獨求敗 --> 孤OO | |||
* Guo da-xia --> GOO | |||
*/ | |||
</pre> | </pre> | ||