newbie question about calculations

[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 mySQL manual, but I still have no clue on how to make 
calculation fields. Right now I have FileMaker talking to mySQL 4.0.15 
using the JDBC driver and a SQL plug-in for Filemaker.  And it is 
working very well, for static data, But....  Anyway, this is a sample 
of my current code to create my Table called, "cart":

CREATE TABLE Cart (
        ID bigint(20) NOT NULL auto_increment ,
        Field1 varchar (5) ,
        Field2 varchar (5) ,
        Field3 varchar (5) ,
            KEY `ID` (`ID`)
)
And code to input data into the table:

INSERT INTO cart (
Field1,
Field2,
Field3  )
VALUES ( '1', '1', '2')
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.

Aloha,

Daryl Hansen

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]