AW: Sql Create a column the multiple of two other columns

2002-07-30 Thread Stefan Klemm
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 b

Re: Sql Create a column the multiple of two other columns

2002-07-30 Thread Ralf Narozny
Hello! James Foley wrote: >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 > > > AFAIK there is no way to automaically set

Re: Sql Create a column the multiple of two other columns

2002-07-30 Thread David Lloyd
[in order to avoid the spam filter] mysql mysql sql [end avoid] (this is a test, I've got the pips with the spam filter when I'm not a spammer -- especially when MOST of the messages from this list register above 3 on http://www.spamassassin.org/) GRUMBLE James Foley wrote: > > Hi, > > If

Sql Create a column the multiple of two other columns

2002-07-30 Thread James Foley
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 --