📄 fulltext_var.test
字号:
## Fulltext configurable parameters#--disable_warningsdrop table if exists t1;--enable_warnings# Save ft_boolean_syntax variablelet $saved_ft_boolean_syntax=`select @@global.ft_boolean_syntax`;show variables like "ft\_%";create table t1 (b text not null);insert t1 values ('aaaaaa bbbbbb cccccc');insert t1 values ('bbbbbb cccccc');insert t1 values ('aaaaaa cccccc');select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);-- error 1229set ft_boolean_syntax=' +-><()~*:""&|';set global ft_boolean_syntax=' +-><()~*:""&|';select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);set global ft_boolean_syntax='@ -><()~*:""&|';select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);select * from t1 where match b against ('+aaaaaa @bbbbbb' in boolean mode);-- error 1231set global ft_boolean_syntax='@ -><()~*:""@|';-- error 1231set global ft_boolean_syntax='+ -><()~*:""@!|';drop table t1;# Restore ft_boolean_syntax variable--disable_query_logeval set global ft_boolean_syntax='$saved_ft_boolean_syntax';--enable_query_log# End of 4.1 tests
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -