I have run into a fairly bizarre issue. Two tables were moved to innodb to take
advantage of row level locking but they were moved back within a day. Both
tables are fixed so updates should not cause table fragmentation and a required
optimize. Also, there are no deletes to the tables in questio
On Fri, 23 Feb 2001, Marty wrote:
> My questions are:
> a) does it matter what order you attempt to update the fields in?
Once again... No
> b) is there a way to view what the warnings were?
and.. Yes. with PHP: mysql_error()
Atle
I am sending a rather large UPDATE query to a table with a handful of
sequential fields (i.e. color1, color2, color3, size1, size2, size3,
etc). The query is generated and executed from within a
PHP script, and to make the script more efficient, the query is
generated with a FOR loop, so that in