var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: copy, and insert row
What I want to do is:
first: copy one record from a table with certain creteria
second: just update two fields (these two fields are part of the key)
third: insert this new record into the same table
This talbe has more than 100 fields. (yeah, I know it sounds ridiculous that the table has more than 100 fields, but this is a very complicated system and that's how the thing works here.)
can somebody please show me how to write the query? If you could provide me with a sample example, that will be great!
, 'newvalue' AS columnM
, 937 AS columnN
WHERE columnM = 'oldvalue'
AND columnN = 21