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.