Re: updating some records in a table

2003-02-10 Thread Zak Greant
On Wed, Jan 15, 2003 at 02:07:42AM -0800, Admin-Stress wrote: > Hi, > > I am new to mySQL, so I need some help. > I have a table, which has record structure like this: > > - customer > - name > - register_date > - expired > > Every day, I add some records, new customers. The field 'expired' is

updating some records in a table

2003-01-15 Thread Admin-Stress
Hi, I am new to mySQL, so I need some help. I have a table, which has record structure like this: - customer - name - register_date - expired Every day, I add some records, new customers. The field 'expired' is just a flag, either '1' or '0'. If register_date is 3 months ago then expired = 1.