MySQL 提供 Master/Slave 機制讓您輕易的完成多個 MySQL Server 之間的資料同步，有了多個資料同步的 MySQL Server 在管理上會較有彈性，例如你可以建置備援主機或是進行負載平衡等等。但是

Continuing from my earlier post on PHP performance, I thought I’d share a few Mysql tips that I’ve learnt over the years. Hope it helps someone and please leave a comment with your own tips or provide any corrections to the ones mentioned. Word searching 1. SELECT * FROM TABLE WHERE MATCH (`field`) AGAINST ('Keyword') (Fastest) 2. SELECT * FROM TABLE WHERE MATCH (`field`) AGAINST ('+Keyword' IN BOOLEAN MODE) (Fast)

SELECT * FROM Product ORDER BY SellDate DESC 因為資料的SellDate可能同時會有幾十筆都相同，我希望可以在篩選出這批資料後在更詳細的依照他們的編號去做排序…