-
Moving data from Sql Server to MySQL
To move data from Sql Server to MySQL, it is certainly possible to use tools that can make connections to both data stores and manipulate data that way, such as Access, Excel, or SSIS. Here I will introduce a process that does not need any special tools or data drivers. Instead, we can use the…
-
Dropping a table does not remove permissions granted to it in MySQL
If: 1. A table t1 is created in database test; 2. A login is granted select permission on t1; 3. t1 is dropped and then recreated. Then that login would still be able to read the newly recreated table t1, even if t1 has totally different columns. The reason is that the table select privilege…
-
Perl script to convert MySQL character set to utf8
“Groovy, baby!”, as international man of mystery likes to say. It seems converting character and text data to utf8 character set is a common task for MySQL, especially during an upgrade. In fact, I had trouble with it during server and WordPress database upgrade for this blog site. I wrote about it in this post,…
-
峨嵋小馆
Rockville是华盛顿特区在马里兰州的郊区。之前我来这儿好几次了。这次来之前，我查了一下这儿的中餐馆，找到了一个名字叫“峨嵋小馆”的地方。它离我的旅馆很近，走得到，挺好的。这儿交通也很方便，坐往Shady Grove方向的Metro红线，Twinbrook站下车，再走六七分钟就到。 Joe’s Noodle House 1488-C Rockville Pike Rockville, Maryland 301-881-5518 http://www.joesnoodlehouse.com 这里的菜不错，服务员也好，很讲礼貌。和她们闲聊，感觉得到她们的友好与温暖。她们有从河北和广东来的。在那儿做打扫工作擦桌子的是一位拉美裔的女士。看着他们用基本的英语和手势交流，开玩笑的一个片段，和他们脸上的笑容，真好。就想，我们能不能抛开肤色，外貌，宗教，语言等的差异，摈弃对与自己不同的群体的贬低、非人化和妖魔化或盲目崇拜，向以人为本的方向努力？ 贴几张这个小馆的菜的照片。明天有可能和网上认识的Prince Roy会面，期待中。现在该回去做一些Linux，MySQL，和Perl之类的东西。千里之行，始于足下。 梅酒，拌豆腐，红油抄手，和辣椒小炒 蒜炒菠菜和夫妻肺片
-
Masking a CSV file through shuffling
I wrote a bit on data masking here. Below is a simple C# program to reshuffle data in a csv file. It uses FileHelpers library for the .Net Framework. To play with this simple code, first download FileHelpers library. Then save the text below the C# code into a file, modify the code to so…