Re: Record Locking on Linked MySQL Tables

[Brett Bavar]

Well, I think I've resolved the problem now. It turns out that all of my timestamps were still null, and I guess that a record with a null timestamp cannot be edited...

Anyway, now I am trying to create a script to automatically set all of the timestamps in every table to the current time, but it always stops after the first line, without an error. The script looks like the following:

UPDATE `tablename1` SET `time_stamp`=now();

UPDATE `tablename2` SET `time_stamp`=now();

......

The query runs properly for the first table on the script every time, but then it never actually updates the second through last tables. It finishes without an error message, but something isn't working right. Is there something wrong with the way I wrote the script?