CODEWITHSUNDEEP
mysqlmariadb
The Broken Ace
The Broken Ace

Reputation: 51

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version error

CREATE TABLE `logins` (`network` varchar(64),`email` varchar(64),`password` varchar(64));

Gives me the error:

"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE logins (network varchar(64),email varchar(64), password var' at line 1"

How can I fix this? Removing ` does nothing.

Upvotes: 0

Views: 2544

Answers (1)

bithead
bithead

Reputation: 1

I had the same error. The problem was copy/paste as suggested above, but not due to control characters. The font used in the source showed back-ticks and forward-ticks in place of single quotes. Replacing those with basic single quote characters solved it for me.

Upvotes: 0

Related Questions