> I'm creating a table where one column will be prices. How is this type > supposed to work? I tried it, loaded the data, and it cuts it off at the > decimal when I run a query. How can I get this to store correctly?
Use a column type such as DECIMAL. http://www.mysql.com/doc/en/Column_types.html ---John Holmes... --------------------------------------------------------------------- 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