Unable to store data in table

Question

INSERT INTO sampledata (name, email, pasword)
VALUES (tony, tonymail, 123pass);

above is the query I am writing to store some data inside my table which has column as following

id AUTO_INCREMENT, 
name varchar(50),
email varchar(50),
password varchar(50);

BUT I AM GETTING ERROR ~

Unknown column 'tony' in 'field list

The value needs to be surrounded by quotes. `'tony', 'tonymail', '123pass'`. — shahkalpesh, Oct 13 '22 at 10:27
___Additional Note___ If the column is called `password` then this is also wrong `INSERT INTO sampledata (name, email, pasword)` — RiggsFolly, Oct 13 '22 at 10:32

score 0 · Accepted Answer · answered Oct 13 '22 at 10:27

0

If this is MySQL, you are supposed to put the VALUES in quotation.

So what you should be writing is

INSERT INTO sampledata (name, email, password) VALUES ("tony", "tonymail", "123pass");

answered Oct 13 '22 at 10:27

Donald Wisdom

This has nothing to do with MY SQL, but with the data type. Strings must also be quoted in other DB's. – Jonas Metzler Oct 13 '22 at 11:02

1 Answers1