The Ji Village News

Author: Haidong Ji

  • Perl script to split sql script into separate files

    Below is a quick script I put together to split one single file that contains many stored procedures into many files that contain just a single stored procedure. It can be easily modified for views, user-defined functions, etc.. Notes: 1. It does put BEGIN and END before and after the procedure creation. Because some script…

  • 推荐李老师的博客

    我的网站右侧的博客链接一直有李老师的“水边树木笔记”。真得很喜欢他的博客，因为他的文笔好，摄影图片耐看，是火腿无线电爱好者。但更重要的是，李老师奋斗在教育战线多年，为厦门本地人以及外来人口如民工等人的孩子的教育做出了实实在在的贡献。不信请看这些链接。 阻止超载车上路 回答一个咨询邮件 关于小学入学的邮件 这样的人才真正值得佩服！咋咋呼呼，人五人六，上纲上线，一知半解，大放厥词，主观臆断的傻逼算老几？

  • Calling MySQL fans in the near west suburb of Chicago

    I’ve been to the Chicago MySQL meetups a few times at Uncommon Ground near Wriggly Field. Honestly I don’t think I gained much out of it. The few times I was there, the group was small, which is not necessarily bad. (In fact, a small group can even be a good thing.) But the thing…

  • Generate insert scripts for SQL Server tables with Perl

    Here is a quick hack with Perl to generate insert statements to reproduce data already exist in a given table. It is similar to results mysqldump generates. A few things worth mentioning here: 1. This script uses a text file, TableList, that contains a list of tables that you want insert statements created. Each line…

  • ActiveState Perl 5.10, Windows XP, and DBD-mysql

    A few months ago I installed ActivePerl 5.10 on a Windows XP Pro workstation. Next I tried to install DBD::mysql using CPAN, it failed. When I browsed modules via ppm, a GUI in this version of ActiveState Perl on Windows, DBD::mysql was not listed as an available module. I then downloaded the source code, manually…