반응형
update TABLENAME t
set COLUMN_NAME = (select COLUMN_NAMEfrom TABLENAME where CASE and CASE) , COLUMN_NAME= (select COLUMN_NAME from TABLENAME where CASE and CASE)
set COLUMN_NAME = (select COLUMN_NAMEfrom TABLENAME where CASE and CASE) , COLUMN_NAME= (select COLUMN_NAME from TABLENAME where CASE and CASE)
반응형