CODEWITHSUNDEEP
mysqlphpmyadmin
user6862997
user6862997

Reputation: 1

MySQL INSERT INTO results in Unknown Column in Field List

I am using the SQL feature phpMyAdmin to add 1 single record into my table. For simplicity, the record will be blank except for the 'symbol' field.

Table structure:

token_id = auto-increment, primary key

symbol = varchar(255)

every thing else is set to allow null entires, so should be irrelevant

I have tried the following queries, but all result in the same error: unknown column 'symbol' in 'field list'

What I have tried:

INSERT INTO tokens (symbol) VALUES ('XYZ');

INSERT INTO tokens (symbol) VALUES ("XYZ");

INSERT INTO tokens (symbol) VALUES (XYZ);

INSERT INTO tokens.symbol VALUES ('XYZ');

INSERT INTO `tokens`.`symbol` VALUES ('XYZ');

Any suggestions?

Just for reference, trying the INSERT and using all columns and setting them to null results in the same exact error.

Upvotes: 0

Views: 743

Answers (1)

user2246924
user2246924

Reputation: 105

The correct format with backticks is INSERT INTO tokens (symbol) VALUES ('XYZ');

FYI, I tried your first query on my server and worked fine so might be a problem with table structure.

Upvotes: 1

Related Questions