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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
