Error Code: 1054, Unknown column on a simple input

Question

I keep getting an error code when I try to input data into a table. the table and input schema are below. Am I doing something wrong? I feel like I have don't this before, many times, without fault.

CREATE database bamazon;

DROP DATABASE IF EXISTS bamazon;

USE bamazon;

CREATE TABLE product (
  id INT NOT NULL AUTO_INCREMENT,
  product_name VARCHAR(60) NOT NULL,
  department_name VARCHAR(60) NOT NULL,
  price DECIMAL (10, 4) NOT NULL,
  stock_quantity INT (4) NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO product ( product_name, department_name, price, stock_quantity)
VALUES ("simpsonwave_vol_1", "trap_vidz", 29.99, 100);

Error code: Error Code: 1054. Unknown column 'simpsonwave_vol_1' in 'field list'

values should be wrap with `single quote` **not** double quotes. eg. `VALUES ('simpsonwave_vol_1', 'trap_vidz', 29.99, 100)` — John Woo, Feb 20 '18 at 02:42

score 0 · Accepted Answer · answered Feb 20 '18 at 09:06

0

use single quotes instead of double INSERT INTO product ( product_name, department_name, price, stock_quantity) VALUES ('simpsonwave_vol_1', 'trap_vidz', 29.99, 100);

answered Feb 20 '18 at 09:06

Satish Gupta

333
1
12

score 0 · Answer 2 · answered Feb 20 '18 at 09:15

Place DROP DATABASE IF EXISTS bamazon; line on top. The code will be like:

DROP DATABASE IF EXISTS bamazon;

CREATE database bamazon;

USE bamazon;

CREATE TABLE product (
  id INT NOT NULL AUTO_INCREMENT,
  product_name VARCHAR(60) NOT NULL,
  department_name VARCHAR(60) NOT NULL,
  price DECIMAL (10, 4) NOT NULL,
  stock_quantity INT (4) NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO product ( product_name, department_name, price, stock_quantity)
VALUES ("simpsonwave_vol_1", "trap_vidz", 29.99, 100);

Error Code: 1054, Unknown column on a simple input

2 Answers2