| mitest | CREATE TABLE `mitest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`myfull1` varchar(20) DEFAULT NULL,
`myfull2` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `myfk` (`myfull1`,`myfull2`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 |==============================================================+----+-------------+-----------+
| id | myfull1 | myfull2 |
+----+-------------+-----------+
| 3 | myfirst | mysecond |
+----+-------------+-----------+==============================================================select * from mitest where match (myfull1,myfull2) against ('second');===============================================================
其中最上面是表结构,中间是表数据,下面是sql语句。执行sql语句后显示"empty set (0.00 sec)" 。为什么没能显示那条记录呢?
`id` int(11) NOT NULL AUTO_INCREMENT,
`myfull1` varchar(20) DEFAULT NULL,
`myfull2` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `myfk` (`myfull1`,`myfull2`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 |==============================================================+----+-------------+-----------+
| id | myfull1 | myfull2 |
+----+-------------+-----------+
| 3 | myfirst | mysecond |
+----+-------------+-----------+==============================================================select * from mitest where match (myfull1,myfull2) against ('second');===============================================================
其中最上面是表结构,中间是表数据,下面是sql语句。执行sql语句后显示"empty set (0.00 sec)" 。为什么没能显示那条记录呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货