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.