MySQLTuner Result

Hi list, I have problem with mysqltuner result. My server has 1 2.2G quadcore proccessor, 16GB RAM and with this my.cnf configuration: # * Fine Tuning # key_buffer = 8G max_allowed_packet = 2G thread_stack= 4M thread_cache_size = 256 key_buffer_size =

query help

Hi, I have a table with product_name, price field. The product name may be exist in more than one record. I only want to view the product per product name which has the lowest price. Please help me to build such query, many thanks for your helps. Regards Willy -- MySQL General Mailing List F

Re: ORDER BY RAND() gives me duplicate rows sometimes

Add DISTINCT(primary_key) in your query? Regards Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]