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 and REAL(x,2) and that was close. Then I
looked at 'info mysql' and went to numerals and down to the section
talking about what to use. There it said if your table has money things
like salary you use DECIMAL(x,2). I have that now in my DB and as I
Query money now it looks like money.
I have not yet found how I can put a $ in front of all the money
columns :-)
But to date I have become real pleased with mysql and all the SQL I
learned from using Oracle works fine.
Karl Larsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
