[thelist] mysql error using select to update - resolved X 2
jft
jft at worrigee.net
Thu Jan 15 14:28:14 CST 2009
Bob,
The idea I intended to convey earlier is different to the idea you received.
The update you want to do can be done in one single-line statement, it does not need a temporary table at all.
> In this case we will assume 118 to be the ID we want to mimic
> and 110 as the ID of the content item we want to update:
Try this:
update jos_content a, jos_content b set a.attribs = b.attribs where a.id = 110 and b.id = 118;
HTH,
John
More information about the thelist
mailing list