EVOLUTION-MANAGER

Edit File: fulltext_multiple_column_index_update.result

drop table if exists diaries; set names utf8; create table diaries ( id int primary key, title varchar(255), content text, fulltext index (title, content), fulltext index (title), fulltext index (content) ) default charset utf8; insert into diaries values(1, "Hello", "はじめました。"); insert into diaries values(2, "天気", "明日の富士山の天気について"); insert into diaries values(3, "富士山", "今日もきれい。"); update diaries set title = "チョモランマ" where id = 3; update diaries set content = "チョモランマと富士山" where id = 1; select * from diaries where match(title, content) against("富士山"); id title content 1 Hello チョモランマと富士山 2 天気 明日の富士山の天気について select * from diaries where match(title) against("富士山"); id title content select * from diaries where match(content) against("富士山"); id title content 1 Hello チョモランマと富士山 2 天気 明日の富士山の天気について drop table diaries;