RE: How to start & use MySQL in Windows

2002-12-15 Thread Haksun Li
Run \mysql\bin\mysql It is the client program. After connecting, you can start using mysql, e.g. use dbname; show tables; etc. etc. Haksun > -Original Message- > From: tmb [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 15, 2002 11:26 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTE

RE: mysql join problem (bug?)

2002-12-01 Thread Haksun Li
> > > > 1 4 1 4 > > If that is the case, is this a Win-XP specific bug? Can someone running versions other than MySQL 4.0.5-beta on XP verify if it is a bug please? Thanks! Haksun > -Original Message- > From: DL Neil [mailto:[EMAIL PROTECTED]] > Sent: Sunday, D

mysql join problem (bug?)

2002-11-30 Thread Haksun Li
Hi all, I found this join problem using mysql 3.23.53-max-nt (on WinXP). It works fine on MySQL 3.23.52-log (on Linux). Could someone please confirm that it is a bug? Or enlighten me on writing the correct sql? I have a table and data as shown in the script below. CREATE TABLE t