Question

MySQL数据删除报错，提示unknown column

建表：
CREATE TABLE SKT74 (
SKF1072 VARCHAR (255) NOT NULL DEFAULT '',
SKF1073 VARCHAR (255) NULL DEFAULT '',
SKF1074 VARCHAR (255) NULL DEFAULT '',
SKF1075 VARCHAR (255) NULL DEFAULT '',
SKF1076 VARCHAR (255) NULL DEFAULT '',
SKF1077 VARCHAR (32) NULL DEFAULT '',
SKF1078 TEXT NULL DEFAULT '',
SKF1079 TEXT NULL DEFAULT '',
SF_CREATE_USER INT NULL,
SF_LAST_CHANGE_USER INT NULL,
SF_CREATE_TIME DATETIME NULL,
SF_LAST_CHANGE_TIME DATETIME NULL,
SKF1426 DECIMAL (24, 4) NULL,
SKF1427 DECIMAL (24, 4) NULL,
SKF1428 DECIMAL (24, 4) NULL,
SKF1598 DECIMAL (24, 4) NULL,
SKF1599 DECIMAL (24, 4) NULL,
SKF1600 DECIMAL (24, 4) NULL,
SKF1601 DECIMAL (24, 4) NULL DEFAULT 0,
SKF1602 DECIMAL (24, 4) NULL,
SKF1623 DECIMAL (24, 4) NULL,
SKF3475 VARCHAR (128) NULL DEFAULT '',
SKF3476 VARCHAR (255) NOT NULL DEFAULT '',
SKF3499 VARCHAR (128) NULL DEFAULT '',
SKF3500 VARCHAR (32) NULL DEFAULT '',
SKF3518 VARCHAR (128) NULL DEFAULT '',
SKF3545 DATE NULL,
SKF3560 DECIMAL (24, 2) NULL DEFAULT 0
) ENGINE = INNODB

然后我增加了几条数据，然后delete：DELETE FROM SKT74 的时候提示1054:Unknown column 'SKF1587' in 'where clause'这个错误，可是我根本没有建SKF1587这个列啊！该怎么解决?

Answer 1

把你的delete语句贴上来

Answer 2

delete 字段名 from SKT74 where 条件

Answer 3

是你delete的条件有问题吧?

Answer 4

执行了几遍 你的源码 没出现这个错误啊