mysql,value是关键字吗?发现个bug。。。。难道是我的问题?

-- ----------------------------
-- Table structure for sample_copy1
-- ----------------------------
DROP TABLE IF EXISTS `sample_copy1`;
CREATE TABLE `sample_copy1`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `value` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `key`(`key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

上面是数据库结构脚本。

 

以下这个神奇的脚本:(我严重怀疑value是关键字还是啥的,反正无论等于啥咋都能查到第一条数据)

SELECT * FROM c_900_plus WHERE `value` = 'sadfadsfad阿斯顿发打发第三方阿萨德发多少发电房阿萨德';

 

posted @ 2020-09-15 15:00  说分手后还能做炮友?  阅读(813)  评论(0编辑  收藏  举报