Archive for the 'database' Category

A Little MySQL Trigger Manage Tool

Unfortunately, there is still no trigger management functionality in PHPMyAdmin. I used to create one during DiggMore development. And I need it again these days. So I rewrite it into a separated archive. Here you can get it: http://binzywu.com/tmp/trigger.zip

Just modify the config.php to set your database information. Hope it’s useful when you need to create trigger in MySQL. Good luck.

MySQL vs PostgreSQL

今天Eunge和我讨论为什么MySQL那么不爽,还那么多人用呢? 我说可能是从众心里吧, 并且举了Struts和Webwork的例子. 在postgreSQL有个最新的新闻, MySQL vs PostgreSQL. Cool!!

Database test Apollo 5 - total - MySQL 5.0.20a

Database test Apollo 5 - total - PostgreSQL 8.2-dev

Varchar in MySQL

我对MySQL的知识还停留在4.0的版本上. 那天朋友发了个sql过来, 我随口就说了varchar错了, Length不能大于255. 结果被狠狠BS了…

4之前, 1-255.
4之后是, 0-255.
5以后则是0-65,535. 不过还与row最大size和使用的character有关. 实际的最大有效长度是65,532字节.

看来以后要踏踏实实, 并且与时俱进啊…