DB design question

2005-05-24 Thread Koon Yue Lam
Hi, here is the case: one student may have more than one address, and one student may have more than one phone number so the db would be: student student_id name age address --- address_id student_id street_name phone_num -- student_id num

[OT] For those who love fur, please take a look

2005-02-16 Thread Koon Yue Lam
** Be prepared, rate R ** http://hk.geocities.com/blood1213/fur.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question on data access object

2005-01-10 Thread Koon Yue Lam
Hi, is it is not the place to discuss DAO, ignore me and sorry ^^ but I have a question about DAO, I write my DAO and include all function that to select / insert / update / delete record from database. Therefore all interaction between database and the outside world are by DAO. No direct access

I want cluster, can I use MySQL?

2004-11-25 Thread Koon Yue Lam
Hi list ! I want a high availability DB whcih means I need failover andload balancing. Can I use MySQL cluster to achieve this? becasue MySQL cluster is only in gramma, I wonder if I can use it in a commerical environment. Also if my website is commerical, do I need to have commerical license of

MySQL Client unicode program

2004-11-15 Thread Koon Yue Lam
Hi, I am using MySQL 4.1.1 and all databases, columns are set to UTF-8 encoding I have try both MySQL cc and Query browser and try to enter some Chinese character, but when I print out the HEX value of the character. It isn't in Unicode that I expected, but i can't see those Chinese character