Re: newbie question about calculations

2003-12-29 Thread Director General: NEFACOMP
nt: Saturday, December 27, 2003 10:59 Subject: newbie question about calculations > Please excuse me if I do not use the correct terminology for what I am > trying to descibe. I am new to mySQL and am using FileMaker and Lass to > export Filemaker data for use with mySQL. How do you make a fiel

Re: newbie question about calculations

2003-12-27 Thread Steve Folly
On 27 Dec 2003, at 21:04, daryl hansen wrote: I can't find anything in the manual about proper syntax for this when creating a table. All I want is my "Price" field to equal the total of my "Adults" and "Children" fields. Can someone please draw me a picture? CREATE TABLE Cart ( ID bi

Re: newbie question about calculations

2003-12-27 Thread Steve Folly
On 27 Dec 2003, at 08:59, daryl hansen wrote: How do I make "Field3" a calculation, which equals 2 if fields 1 & 2 where values set to "1"? Any pointers in the right direction would be sincerely appreciated. Take a look at 6.3.1.3 and 6.3.1.4 in the MySQL documentation for logical operators a

newbie question about calculations

2003-12-27 Thread daryl hansen
Please excuse me if I do not use the correct terminology for what I am trying to descibe. I am new to mySQL and am using FileMaker and Lass to export Filemaker data for use with mySQL. How do you make a field that is the sum of two other fields in the same record? I have riffled through the myS