Not the answer you need?
Register and ask your own question!

Limitations on tables w/o primary keys

ctbenctben EntrantCurrent User Role Beginner

Just noticed that :-

"DELETE operation is unsupported on tables without primary key. Also rows in tables without primary key may appear in different order on different nodes. As a result SELECT...LIMIT... may return slightly different sets."

has been removed from but is still present in the pdf manual. Has that limitation been removed and the pdf not yet updated or is the web page wrong?




Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.