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