Hello,
Iam a OpenBSD user. I would like to know if there is any technique
specific to the US to be able to benchmark the IO for this OS. Also,
what result would be considered acceptable and what is not.
Thanks!!
Andres
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
> At 08:59 PM 2/27/2010, you wrote:
>>Hello everyone,
>>
>>How would I select a random row that changes daily?
>>
>>Thanks
>
> The common way would be to do:
>
> select * from table order by rand() limit 1;
>
> You can of course add a Where clause to select only those rows that were
> added today.
SET @string := '1a4b';
SELECT CONV(@string,16,10);
+-+
| CONV(@string,16,10) |
+-+
| 6731
Thanks. That works perfectly.
Much appreciated.
On February 28, 2010, Michael Dykman wrote:
It's still a string, but this should accomplish what you
Oops: This little bit doesn't make sense, logically: "The hex string is
in little endian byte order (since it represents a 2-byte integer or
short)"... What I was trying to say is that the integer that this hex
string represents is multi-byte, so the order of the hex bytes **is**
important..
Oops: This little bit doesn't make sense, logically: "The hex string is
in little endian byte order (since it represents a 2-byte integer or
short)"... What I was trying to say is that the integer that this hex
string represents is multi-byte, so the order of the hex bytes **is**
important..
I've tried several ways to get my hex-encoded string representation of
an integer to convert back to an integer, but none of them work (the
input string '1a4b' should evaluate to 6731):
(Note that this is not an endianness problem. The hex string is in
little endian byte order (since it rep
