You don't need another column. SQL can calculate: select a, b, c, b * c as WhatEverYouWant from ....
[WhatEverYouWant contains the product of column b and c] -----Ursprüngliche Nachricht----- Von: James Foley [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. Juli 2002 13:34 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Sql Create a column the multiple of two other columns Hi, If this is trivial, please bare with me: How do I alter a table in Sql to add a column which is the multiple of two existing columns: A Table has columns a,b,c and I want to add column d which will be b*c Many Thanks Beginner --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- 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
