Hello list
I need to solve a little problem but don't mind how, maybe you could suggest
something.
I have a database which registers payments, records have a AUTO_INCREMENT
field to assign a unique consecutive number associated to every payment, some
other fields that store the amount, type of payment, etc. and another
TIMESTAMP field that stores the date and time.
One of the fields contains the username for who received the payment and it is
stored automatically by the software, so I can know who processed the
payment, when, and all related information...
In the first stage of the system it worked only for 'localhost' and a unique
test user, so all my current payments have registered that user. Now the
system is able to select a host and a user, so I want to update the test user
username for a real user, the database has already some records and would not
like to reenter them by hand logging in as a real user.
My problem is this... if I update the username field, the TIMESTAMP updates
the date and time of the payment to the current values and the payment
date/time does not coincide then...
Is there a way to update only that one field avoiding the TIMESTAMP update?
One way is to update both fields, specifying the user and the same date/time
by hand, but comes a new problem, payments have different date and time, so I
would need to create a small routine to update records one by one with its
particular date/time, but maybe there is another way to do it with a single
command...
Thanks for any comment
