UPDATE table SET field = 'Done' WHERE ISNULL(field) LIMIT 765;> 1
> I have a table in which I need to change a value in a field (from null to
> "done") for the first 765 posts.
Leave off the LIMIT clause if you want to change all occurrences of
Also, consider creating a new table of statuses(status*)
I use PHPMyAdmin,textpad and the command prompt. Navicat's also> 2
> What user interface for MySQL do most people use?
Er, 'timestamp' !?!> 3
> I would like to time and date stamp the user entries I collect from users on
> my website. Is there an internal function for this?
Well, 3 out of 4's not bad>
> When a user clicks enter after entering data on the user form I would like
> to present him/her with a unique index numer which they can then quote to me
> when inquring about their entry. Obviously I need to enter this number into
> the table as well. However I can not read in the highest number from the
> field and "add 1" because two users may be entering data at the same time. I
> need to create this number at execution time, and show it to the user when
> the form has been processed on the "confirm" page I display. (I know I can
> fake this effect using a "page hit" counter when displaying the form but
> thats probably not the best way to do this.) Any tips on the best way to
> create a unique number?