Abstract: A method of algorithm implementation for association rules is proposed.It uses the power of data processing in relational database management system to mine data.By Combining Apriori algorithm with the theory of relational algebra,the feasibility of implementing Apriori algorithm by use SQL statement is analyzed,and then,the realization process of method is described.An experimental result on mushroom dataset shows that the method given in this paper is simple and efficient.