Re: Update Doesn't Update!

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: To: "Victor Subervi" Cc: Sent: Fri

different 5.0 and 5.1 about long_query_time

) r...@localhost:(none) 18:36:58>select version(); +---+ | version() | +---+ | 5.1.29-rc-log | +---+ 1 row in set (0.00 sec) __ Best Regards! Yang Wang Email: yw...@lfm-agile.com.hk

Re: Most data sort

B|1 | | A|2 | | C|2 | | D|1 | | C|4 | +--+--+ 10 rows in set (0.00 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

compile 5.5.4-m3 on centos 5.0

make[1]: *** [install] 错误 2 make[1]: Leaving directory `/home/ruochen/mysql-5.5.4-m3/sql' make: *** [install-recursive] 错误 1 = reference: http://bugs.mysql.com/bug.php?id=51740 Best Regards! Yang Wang

Re: compile 5.5.4-m3 on centos 5.0

| NULL| GPL | +-+--++-+-+ 18 rows in set (0.00 sec) Best Regards! Yang Wang - Original Message - From: "Joerg Bruehe" To: Cc: "Yang Wang" Sent: Monday, Apri

Re: starting multiple instances with mysqld_multi

/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" To: "Pra