#1054 - 未知列“de15a674d1252f6565a65756ebfa97e8e1e58c9c”在“where 子句”中

Question

我有两个表

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(20) NOT NULL AUTO_INCREMENT,
  `ud_id` varchar(50) NOT NULL,
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` varchar(200) NOT NULL,
  `image` varchar(150) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB

，mycatch 表是

CREATE TABLE IF NOT EXISTS `mycatch` (
  `catch_id` int(11) NOT NULL AUTO_INCREMENT,
  `catch_name` text NOT NULL,
  `catch_details` text NOT NULL,
  `longitude` float(10,6) NOT NULL,
  `latitude` float(10,6) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `image` varchar(150) NOT NULL,
  `user_id` int(20) NOT NULL,
  PRIMARY KEY (`catch_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB;
ALTER TABLE `mycatch`
  ADD CONSTRAINT `mycatch_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

我想从两个表中检索数据。即，

SELECT longitude,latitude
FROM user u
LEFT JOIN mycatch m ON u.user_id = m.user_id
WHERE u.ud_id =de15a674d1252f6565a65756ebfa97e8e1e58c9c
AND m.catch_id >7

但这给了我错误 #1054 - 'where 子句' 中的未知列 'de15a674d1252f6565a65756ebfa97e8e1e58c9c'
但是当我更改 u.ud_id=123456789 时它工作正常

Answer 1

您需要将 u.ud_id 用单引号引起来

SELECT longitude,latitude
FROM user u
LEFT JOIN mycatch m ON u.user_id = m.user_id
WHERE u.ud_id = 'de15a674d1252f6565a65756ebfa97e8e1e58c9c'
AND m.catch_id >7

Answer 2

您需要将您的值放在引号中：

... WHERE u.ud_id='de15a674d1252f6565a65756ebfa97e8e1e58c9c' ...