Shulou(Shulou.com)06/01 Report--

MariaDB 10.3 supports update multi-table ORDER BY and LIMIT

1) update continuous table update, limit statement

update t1 join t2 on t1.id=t2.id set t1.name='hechunyang' limit 3;

MySQL 8.0 directly reported errors

MariaDB 10.3 update successful

---------------------------------------------------

2) Update, ORDER BY and LIMIT statements

update t1 join t2 on t1.id=t2.id set t1.name='HEchunyang' order by t1.id DESC limit 3;

MySQL 8.0 directly reported errors

MariaDB 10.3 update successful

Reference: jira.mariadb.org/browse/MDEV-13911

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.