mysql #1054 Unknown column using phpmyadmin

Question

CREATE TABLE tblUser (
  User_ID INT NOT NULL AUTO_INCREMENT,
  User_Email VARCHAR(40) NOT NULL,
  User_Password VARCHAR(30) NOT NULL,
  PRIMARY KEY (User_ID)
);

INSERT INTO `tblUser` (`User_Email`, `User_Password`) 
VALUES (`[email protected]`, `password`);

Unknown column '[email protected]' in 'field list'

Answer 1

Use single quotes instead of backticks for strings.

INSERT INTO `tblUser` (`User_Email`, `User_Password`) 
VALUES ('[email protected]', 'password');

Check this link for more explanation.

And I really hope that your passwords are hashed.