Member Avatar for Aeonix

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

Edited by Aeonix
  • 2 Contributors
  • 3 Replies
  • 158 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

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');
Member Avatar for Aeonix

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, networking, learning, and sharing knowledge.