From: Reindl Harald
Date: February 12 2012 5:55pm
Subject: Re: Formatting Numbers with commas
List-Archive: http://lists.mysql.com/mysql/226783
Message-Id: <4F37FCFF.5080909@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigC47B5BA80C74F0F7A6494947"

--------------enigC47B5BA80C74F0F7A6494947
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Am 12.02.2012 16:59, schrieb Mike Blezien:
> Hello,
>=20
> Is there a function to automatically format long numercial values befor=
e 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 ent=
ered 78,450 etc., ?

you do not really want to destroy data this way
if you have numbers store them untouched as numbers
format them in the output however you want

if you do not mess up your data you can change the
output format to whatever you want in the future!


--------------enigC47B5BA80C74F0F7A6494947
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEUEARECAAYFAk83/P8ACgkQhmBjz394AnnEkgCWLzuJ/Tr26ri7NYoUVfcz3Mwh
TACfajAHo0ZH+fbvmdn4/yv4APswn9Y=
=gUX/
-----END PGP SIGNATURE-----

--------------enigC47B5BA80C74F0F7A6494947--