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

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');
Jump to Post

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.