Why is the reserved word available in mysql?

Question

Why was it added as a reserved word for mysql and what was it used for? Is there any documentation for him because I cannot find him.

Answer 1

From what I have compiled, it looks like ACCESSIBLE , READ-ONLY and READ-WRITE - these are the access modes from TABLESPACE s. But there is no documentation.

If you want to know how and when to use it, you will need to read the Oracle documentation .

After searching in mysql 5.1 (when they were entered) the source and trying out some keywords in google, I managed to find this commit . From there, a digging bot in related variables / types in the source, I found about the request for adding TABLESPACE in 5.0> documentation in 5.1> examples of use in Oracle documents.

Answer 2

From the MySQL manual:

"Below are the new reserved words in MySQL 5.1: AVAILABLE LINEAR MASTER_SSL_VERIFY_SERVER_CERT RANGE READ_ONLY READ_WRITE"

There seems to be no documentation describing the use of ACCESSIBLE , so it is most likely reserved for future use.