sql - MySQL: SyntaxError: Unexpected identifier

Question

I just installed MySQL on my computer and when I try to create a database from the MySQL shell, I get this error:

MySQL  JS > CREATE DATABASE databasename;
SyntaxError: Unexpected identifier

Does anyone know why this is happening? Is there a problem with the installation of MySQL?

question from:https://stackoverflow.com/questions/50645402/mysql-syntaxerror-unexpected-identifier

Answer 1

By looking at this thread here, it looks like you might be using the shell in js mode, you might be able to toggle it off by using the switch

sql 

https://forums.mysql.com/read.php?10,661192,661203#msg-661203