Hi guys,
I know nothing about MySQL, but
please check this and make some bucks
http://www.anrdoezrs.net/click-2275618-10459013
Your friend,
Gabusa
Duncan Hill-3 wrote:
On Tuesday 04 July 2006 21:33, Karl Larsen wrote:
I have not yet found how I can put a $ in front of all the money
On Tuesday 04 July 2006 21:33, Karl Larsen wrote:
I have not yet found how I can put a $ in front of all the money
columns :-)
Either use concat() or do it in your program that retrieves the data from
MySQL. Currency symbols are not something the database should have to store
for you
In an older mysql version there was a numerical thing called money
and it was supposed to round all things to just 2 numbers after the
decimal and maybe make sure the 2 numbers exist even if it's a zero. But
this function is not part of mysql version 4.1.
I tried INTEGER and CHAR
Kyle, you're a twat for sending s**t like this to this list...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
To: kyle [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Money making plan
Kyle, you're a twat for sending s**t like this to this list...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General
Yeah, sorry for that language, but I couldn't believe what I had just
read and lost it...
On 17/11/05, Peter J Milanese [EMAIL PROTECTED] wrote:
Don't know if that's the word I'd use, but credibility is lost for that
nonsense. No proffesionalism whatsoever. If I were admin I'd ban for less.
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
Thanks,
Chris
Chris Ripley
[EMAIL PROTECTED]
KOZE Radio
__
Yahoo! Mail - PC Magazine Editors
Chris Ripley wrote:
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
double
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia
Daniel Kasak wrote:
Chris Ripley wrote:
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
double
No way. You should *never* use floating-point types for currency if you
care about
Chris,
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
Someone suggested double, but with big sums that can give you rounding
errors. Try DECIMAL.
PB
--
No virus found
Jasper Bryant-Greene wrote:
No way. You should *never* use floating-point types for currency if
you care about precision. You'll experience all sorts of weird
rounding and comparison errors. See [1] for more information.
DECIMAL would suit your needs better -- from [2]: The DECIMAL and
What do people recommend for storing money amounts? I've seen people use
NUMERIC(18,3) and other use NUMERIC(18,4). Which one is more appropriate
and why? This is considering various existing currencies, some having
low rates (like IDR, in which you can have large amount up to hundreds
At 02:03 2003-12-03, David Garamond wrote:
What do people recommend for storing money amounts? I've seen people use
NUMERIC(18,3) and other use NUMERIC(18,4). Which one is more appropriate
and why? This is considering various existing currencies, some having low
rates (like IDR, in which you
Hi,
Which type do you usually use to keep money values? Decimal (12,2) or Float?
to keep the first one, system takes 12 bytes but for the second one, 8
bytes.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
loose
about 12 cents. Not big losses, but when dealing with financial accounting
it is generally an unacceptable inaccuracy.
Grant Q
-Original Message-
From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 11:56 AM
To: [EMAIL PROTECTED]
Subject: money field
stored.
The 4-byte storage overhead is easily justified by this.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Quinlan, Grant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 15:16
Subject: RE: money field
I would use Decimal (12,2
I use Decimal, because I like my money calculations to be correct.
Mojtaba Faridzad wrote:
Hi,
Which type do you usually use to keep money values? Decimal (12,2) or Float?
to keep the first one, system takes 12 bytes but for the second one, 8
bytes.
Thanks
--
MySQL General Mailing List
I'm porting a MS-SQL system to a Solaris machine running Mysql.
In the MS-SQL there is a datatype of money what would be the proper
datatype in mysql to use as a replacement for this?
Keith
-
Before posting, please check
PM
To: [EMAIL PROTECTED]
Subject: money datatype
I'm porting a MS-SQL system to a Solaris machine running Mysql.
In the MS-SQL there is a datatype of money what would be the proper
datatype in mysql to use as a replacement for this?
Keith
billion dollar a year adult XXX industry by
taking one of our FREE FREE FREE adult web site
businesses and we'll make sure you earn a lot
of money.
Its what over 70% of 250,000,000 surfers
are looking for!
No experience required
Our Guarantee:
'We'll give you a adult web site
devoted an entire show to the
investigation of this program described below, to
see if it really can make people money. The show
also investigated whether or not the program was
legal. Their findings proved once and for all
that there are ''absolutely NO Laws prohibiting
REAL MONEY
Subject: Fw: .AS SEEN ON NATIONAL TV
Subject:REAL MONEY
Dear Friend Future Millionaire:
AS SEEN ON NATIONAL TV:
Make over a half million dollars every 4 to 5 months from your home for
an
investment of only $25 U.S. Dollars one time expense
to the investigation of this program described
below, to see
if it really can make people money. The show also investigated wheather
or not the program was legal. Their findings proved once and for all that
there are absolutely NO LAWS
prohibiting the participation in the program and if people can follow
Dear Mr. Stephen K. Horn, (WHITE HOUSE - USA)
As being as Global Products Information Consultant, I have Invented a totally new
Concept, using which the World's Money systems can be Monitored by using a single
software on the Internet.
Please help me to implement my Invention! I have Lost
24 matches
Mail list logo