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 a
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
f
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 INTEG
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.
/17/2005 05:08 AM
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.c
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]
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
NUME
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
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
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,
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 Magazi
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 whic
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 hundred
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
tered is the value 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
Subj
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
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
3:07 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 thi
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
nvolved with the $35
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.
<<<>>>
"No experience required"
Our Guarantee:
'We'll give you a
this
> letter on the Internet, a national weekly news>
> program recently > 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
Adive, put the Spammer from the e-mail into an access file and
stamp reject next to it.
On Wed, Aug 15, 2001 at 01:14:25AM +, Dan Mitchell wrote:
> REAL MONEY
>
> Subject: Fw: .AS SEEN ON NATIONAL TV
>
>
> >
>
> >
> > > Sub
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 yo
entire show 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
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
25 matches
Mail list logo
