Re: grant tables update backward compatibility

2004-09-04 Thread Bob Hockney
Hi Eric,: Thanks for responding. Preliminary tests indicate no problems, although it does of necessity make assumptions about which of the new privileges existing users should have when upgrading, but they were fairly safe. Regards, -Bob > I would assume that you can since mysql probably doe

Re: Update field base on value from another row

2003-10-22 Thread Bob Hockney
I wrote: > Let's say I have a table with two columns, "id" which is unique and auto > incremented, and "time" which is int(10) unsigned (unix timestamp at time > record is added). Due to earlier problems with my insert statements, some > records do not have a time value (NULL). I want to provide

Update field base on value from another row

2003-10-22 Thread Bob Hockney
Hi there, Let's say I have a table with two columns, "id" which is unique and auto incremented, and "time" which is int(10) unsigned (unix timestamp at time record is added). Due to earlier problems with my insert statements, some records do not have a time value (NULL). I want to provide an