Re: Randomize by Score and DESC

Hi, Thans for the reply, I have tried it but I don't see the RAND() to be work. This list is always the same. TIA Willy -Original Message- From: mos <[EMAIL PROTECTED]> To: sangprabv <[EMAIL PROTECTED]>, mysql@lists.mysql.com Subject: Re: Randomize by Score and DESC Date: Sat, 29 Nov 20

Re: How to find last price of items that were sold?

>Is there a fast way to find the last price of an item that was sold, without doing a table join or subselect? It can be fast but it needs a join, see "Within-group aggregates" at http://www.artfulsoftware.com/infotree/queries.php for examples. PB - mos wrote: Is there a fast way to fin

Re: How to find last price of items that were sold?

At 04:14 PM 11/29/2008, you wrote: mos wrote: The Details table has Product_Code: Char(20), Date_Sold: Date, and Price_Sold: Double. The products are sold for different prices during the month and I need to retrieve the last price it was sold for. select product_code, price_sold, max(date_

Re: How to find last price of items that were sold?

mos wrote: The Details table has Product_Code: Char(20), Date_Sold: Date, and Price_Sold: Double. The products are sold for different prices during the month and I need to retrieve the last price it was sold for. select product_code, price_sold, max(date_sold) from details group by product_

mysql master slave security considerations and planning

Hi, First of all I am newbie to MySQL administration, so if my questions seem weird, please forgive me. I am testing a mysql-slave setup on test nodes and was successful in setting it up. Here are the results. Please note this is a basic setup, I will explore more options that can be added to m

How to find last price of items that were sold?

Is there a fast way to find the last price of an item that was sold, without doing a table join or subselect? The Details table has Product_Code: Char(20), Date_Sold: Date, and Price_Sold: Double. The products are sold for different prices during the month and I need to retrieve the last pric

Re: Randomize by Score and DESC

At 09:15 AM 11/29/2008, sangprabv wrote: Hi, I have a query like this "SELECT * FROM table ORDER BY score DESC, RAND()" The aim is to randomize the result by score with descending order. But it doesn't work. What missed here? TIA. Willy Willy, That is because you are ordering by Score

Re: How to disable some of the mysql query?

Hi wayne, If you dont want any query with select * from " by mistake" then you can start the mysql by using the command --safe-updates or --i-am-a-dummy this does not allow queries to be executed if they dont have any where clause. Regards, Chandru www.mafiree.com On Fri, Nov 28, 2008 at 11:0

Randomize by Score and DESC

Hi, I have a query like this "SELECT * FROM table ORDER BY score DESC, RAND()" The aim is to randomize the result by score with descending order. But it doesn't work. What missed here? TIA. Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

MySQL 5.1 declared "GA"

Hi! If you want to know what to expect from MySQL 5.1 GA and when to start using it, please check my blog at: http://monty-says.blogspot.com/ Regards, Monty Creator of MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com