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

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

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 an