Good day, everyone, and thank you for your time!
I am not a member of the mailing list (I had to swear them off as
addictive =o) but am posting this question in the hope that some
generous soul will assist me anyway.
I am building a database in which I want to restrict the values in one
column to a positive fraction less than 10. UNSIGNED is easy enough,
but when I try to limit the number of significant digits to the left of
the decimal to less than 2 MySQL simply seems to think that I must be
mistaken, and always pads to at least 2 nonfractional digits.
Is there a way to
mysql> create table xmp (
-> this real(5,4)
-> );
Query OK, 0 rows affected (0.01 sec)
so that
mysql> desc xmp;
doesn't come back with
+-------+-------------+
| this | double(6,4) |
+-------+-------------+
?????
(obviously, extraneous data removed from cut&paste.)
Please respond to [EMAIL PROTECTED] and/or [EMAIL PROTECTED] if
this mailing doesn't list [EMAIL PROTECTED] as a possible
REPLY-TO: address.
Thank you again, and please remember I am not privy to the list
directly.
Paul
__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
