MySQL "unknown column"

Question

My database table has columns email, username and password. I'm trying to insert these test values into them, but the query seems to be interpreting the value for the test email in a strange way. What's wrong with this query?

mysql> INSERT INTO `tbl_user`
    -> (`email`, `username`, `password`)
    -> VALUES
    -> (`[email protected]`, `Test_User_One`, MD5(`test1`)),
    -> (`[email protected]`, `Test_User_Two`, MD5(`test2`))
    -> ;
ERROR 1054 (42S22): Unknown column '[email protected]' in 'field list'

Pollett · Accepted Answer · 2011-05-28 23:45:31Z

5

Try using single quotes rather than backticks round the values, i.e.

mysql> INSERT INTO `tbl_user`
-> (`email`, `username`, `password`)
-> VALUES
-> ('[email protected]', 'Test_User_One', MD5('test1')),
-> ('[email protected]', 'Test_User_Two', MD5('test2'))
-> ;

Backticks are used to signify column names whereas single(or double) quotes will be used as a value.

answered May 28, 2011 at 23:45

Pollett

5964 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GolezTrol · Accepted Answer · 2011-05-28 23:45:42Z

1

You're using the wrong quotes for the values. Use simple quotes ' to indicate a char value.

answered May 28, 2011 at 23:45

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

Comments

Lightness Races in Orbit · Accepted Answer · 2011-05-28 23:51:15Z

0

Backticks delimit field names (database names, table names or column names).

Use single or double quotes to delimit strings:

INSERT INTO `tbl_user` (`email`, `username`, `password`)
     VALUES ("[email protected]", "Test_User_One", MD5("test1")),
            ("[email protected]", "Test_User_Two", MD5("test2"));

answered May 28, 2011 at 23:51

Lightness Races in Orbit

387k77 gold badges670 silver badges1.1k bronze badges

Collectives™ on Stack Overflow

MySQL "unknown column"

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related