[thelist] mysql error using select to update

Paul Bennett Paul.Bennett at wcc.govt.nz
Mon Jan 12 13:28:33 CST 2009


Hi Bob,

Are you doing this on the command line? If so, you can use mysql variables to store the information from the select query:

@attribs := select attribs from jos_content where id=191;

update jos_content set attribs =  @attribs where id=180;

Or am I missing something?

Paul;



More information about the thelist mailing list