//更新值為文本,加"" UPDATE xxxx SET controller='Live' WHERE mold=1; //更新值為數字 UPDATE xxx SET tpye=1 WHERE mold=2;