In the last episode (Jan 25), Graham said: > I have looked at the documentation and have been unable to locate any > information in respect of calculated fields. Can anyone verify the > lack of this feature in mysql or point me to the area of the > documentation which discusses them if the are indeed included. If > they are not available has anyone suggestions for how I may work > around this lack of functionality.
MySQL does not support views (which is what I assume you're talking about). Either add another physical field, and do the calculation as you insert the rest of the data, or calculate the field on the fly as you select. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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