Re: starting multiple instances with mysqld_multi

2010-05-14 Thread Yang Wang
/opt/MySQL607start.sh /opt/MySQL607/bin/mysqld_multi start 607 -bash-3.1# cat /opt/MySQL607stop.sh /opt/MySQL607/bin/mysqld_multi stop 607 == Best Regards! Yang Wang Email: yw...@lfm-agile.com.hk - Original Message - From: Nitin Mehta ntn...@yahoo.com

Re: compile 5.5.4-m3 on centos 5.0

2010-04-19 Thread Yang Wang
rows in set (0.00 sec) Best Regards! Yang Wang - Original Message - From: Joerg Bruehe joerg.bru...@sun.com To: mysql@lists.mysql.com Cc: Yang Wang yw...@lfm-agile.com.hk Sent

Re: Most data sort

2009-12-21 Thread Yang Wang
sec) mysql select name,sum(qty) as qty from t2 group by name order by qty desc; +--+--+ | name | qty | +--+--+ | A|9 | | C|6 | | B|3 | | D|1 | +--+--+ 4 rows in set (0.01 sec) Best Regards! Yang Wang - Original Message - From

Re: Update Doesn't Update!

2009-12-11 Thread Yang Wang
first desc products or try to update products set sizes='Small' where SKU='prodSKU1'; Best Regards! Yang Wang Tel.: 0769-21687397 Fax.: 0769-21685577 Email: yw...@lfm-agile.com.hk - Original Message - From: cars...@bitbybit.dk To: Victor Subervi victorsube...@gmail.com Cc: mysql

different 5.0 and 5.1 about long_query_time

2009-12-11 Thread Yang Wang
() | +---+ | 5.1.29-rc-log | +---+ 1 row in set (0.00 sec) __ Best Regards! Yang Wang Email: yw...@lfm-agile.com.hk