“此处不允许的列"； INSERT语句中的错误 [英] "column not allowed here" error in INSERT statement

问题描述

我创建了名为LOCATION的表 通过这样做:

I created this table called LOCATION by doing this:

CREATE TABLE LOCATION(
POSTCODE VARCHAR(10) PRIMARY KEY,
STREET_NAME VARCHAR(20),
CITY VARCHAR(20));

当我尝试在表格中添加一些日期时，说有错误，这是行不通的

and when I try to add some date within the table it doesn’t work saying there is an error

INSERT INTO LOCATION VALUES(PQ95VM,'HAPPY_STREET','FRANCE');

错误是

此处不允许的列

column not allowed here

推荐答案

您在第一个值附近缺少引号，应该是

You're missing quotes around the first value, it should be

INSERT INTO LOCATION VALUES('PQ95VM', 'HAPPY_STREET', 'FRANCE');

顺便说一句，出于可读性，可维护性和鲁棒性的考虑，建议您在INSERT中显式指定列名称.

Incidentally, you'd be well-advised to specify the column names explicitly in the INSERT, for reasons of readability, maintainability and robustness, i.e.

INSERT INTO LOCATION (POSTCODE, STREET_NAME, CITY) VALUES ('PQ95VM', 'HAPPY_STREET', 'FRANCE');

这篇关于“此处不允许的列"； INSERT语句中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！