““字段列表"中的未知列"，但该列确实存在 [英] "Unknown column in 'field list'", but column does exist

问题描述

DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `transactions` (`purchase_date`) VALUES (NULL)

我在这段代码中隔离了我的问题.运行它时，出现错误:

I've isolated my problem in this code. When I run it, I get the error:

[查询3中的错误]字段列表"中的未知列"purchase_date"

[ERROR in query 3] Unknown column 'purchase_date' in 'field list'

有人知道吗?

推荐答案

在INSERT语句的purchase_date和'之间插入了一个不可打印的字符30(RecordSeparator).只需删除文本('purchase_date')并手工重写就可以了.

There is an unprintable character 30 (RecordSeparator) inserted between purchase_date and the ' in the INSERT statement. Just remove the text ('purchase_date') and rewrite it by hand it should be fine.

这篇关于““字段列表"中的未知列"，但该列确实存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！