On 2/12/2012 4:40 PM, Reindl Harald wrote:
Am 12.02.2012 23:25, schrieb Cabbar Duzayak:
Hi All,
I have a table with a btree index on its searchKey column, and when I
send a simple query on this table:
explain select * from DataIndex where (searchKey like 'A%') order by
searchKey limit 10
rows
Am 12.02.2012 23:25, schrieb Cabbar Duzayak:
> Hi All,
>
> I have a table with a btree index on its searchKey column, and when I
> send a simple query on this table:
>
> explain select * from DataIndex where (searchKey like 'A%') order by
> searchKey limit 10
>
> rows is returning 59548 and it
Am 12.02.2012 16:59, schrieb Mike Blezien:
> Hello,
>
> Is there a function to automatically format long numercial values before it's
> entered into the table, i.e I have a
> value like 159600 and would be entered as 159,600 or 78450 would be entered
> 78,450 etc., ?
you do not really want to d
Thank you Simon exactly what I was looking for. Appreciate the assistance.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Original Messa
Please see
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format
Regards,
Simon Griffiths
-Original Message-
From: Mike Blezien [mailto:mick...@frontiernet.net]
Sent: 12 February 2012 16:00
To: MySQL List
Subject: Formatting Numbers with commas
Hello,
Is there