Re: Comparing multiple field values
Posted by:
Ben Alger
Date: April 10, 2014 02:27PM
Would the structure help? I can't create a new table.
# Name Type Collation Attributes Null Default Extra Action
1 rateId int(11) No None AUTO_INCREMENT
2 rateType enum('type1', 'type1, 'type_ utf8_general_ci No type1
3 payMethod varchar(4) utf8_general_ci No
4 company varchar(4) utf8_general_ci No
5 activated char(1) utf8_general_ci No N
6 amount1 double(8,2) No 0.00
7 lastUpdated timestamp on update CURRENT_TIMESTAMP No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Thanks again for all the help.
Subject
Written By
Posted
Re: Comparing multiple field values
April 10, 2014 02:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.