mysql update select limit
问题:mysql连表更新limit数据错误
UPDATE table_a SET col_name_1 = '固定值'
WHERE col_name_2 in (select col_name_1, col_name_2 from table_a LIMIT 6)
执行结果:This version of MySQL doesn't yet support 'LIMIT & IN/...
原创
2019-10-28 16:32:36 ·
297 阅读 ·
0 评论