1: UPDATE `p9s_category`
2: SET `footer_module` =(
3: SELECT `footer_module` FROM (
4: SELECT * FROM `p9s_category`
5: ) AS X
7: WHERE catid=24)
8: WHERE catid=4
2: SET `footer_module` =(
3: SELECT `footer_module` FROM (
4: SELECT * FROM `p9s_category`
5: ) AS X
7: WHERE catid=24)
8: WHERE catid=4
转载请注明：XAMPP中文组官网 » Mysql 一句SQL用数据库字段更新指定字段