INSERT INTO 'members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')

-

#1064 - 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 ''members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')' at line 1

Recommended Answers

All 3 Replies

Hi, don't use single or double quotes around table and column names, otherwise these are interpreted as strings, use backticks, so:

INSERT INTO `members` (`username`, `password`, `email`) VALUES ('axe', 'axe', 'weql');

THAT'S SO STUPID... QUOTE IS QUOTE.. :|
Oh well. Not my rules... not my game... thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.