MariaDB 10 3支撑update多表ORDER BY and LIMIT
发布时间:2022-07-01 10:24 所属栏目:115 来源:互联网
导读:
导读:MariaDB 10.3支持update多表ORDER BY and LIMIT 1)update连表更新,limit语句 update t1 join t2 on t1.id=t2.id set t1.name=hechunyang limit 3; MySQL 8.0 直接报错 MariaDB 10.3 更新成功 2)update连表更新,ORDER BY and LIMIT语句 update t1 join t2
MariaDB 10.3支持update多表ORDER BY and LIMIT 1)update连表更新,limit语句 update t1 join t2 on t1.id=t2.id set t1.name='hechunyang' limit 3; MySQL 8.0 直接报错 MariaDB 10.3 更新成功 2)update连表更新,ORDER BY and LIMIT语句 update t1 join t2 on t1.id=t2.id set t1.name='HEchunyang' order by t1.id DESC limit 3; MySQL 8.0 直接报错 MariaDB 10.3 更新成功 (编辑:ASP站长网) |
相关内容
网友评论
推荐文章
热点阅读