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
Jump to PostHi, 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');
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.
You can enable the compatibility to the ANSI standard by switching the SQL mode, see:
With that you, then, can use double quotes to define the identifiers.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.