Reserved Words in memSQL

Where can I get the list of reserved words in memSQL?

We don’t have that published right now, but we have an open task to get it added to our documentation. I updated it with your request.

In the meantime, if your apps are generating identifiers, you can put backquotes around them to avoid any potential problems. E.g.

memsql> create table `SELECT` (`a` int);
Query OK, 0 rows affected (0.10 sec)

memsql> insert `SELECT` values(1);
Query OK, 1 row affected (0.08 sec)

memsql> select * from `SELECT`;
| a    |
|    1 |

If your developers are generating SQL by hand, they can fix any syntax errors they see if they inadvertently use a reserved word in the wrong place.