⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
innodb
/
r
/
View File Name :
innodb_fts_limit_check.result
create table t ( FTS_DOC_ID bigint unsigned not null, contents text collate utf8mb4_bin, primary key (FTS_DOC_ID), fulltext key fx_contents (contents) with parser ngram ) engine=innodb default charset=utf8mb4 collate=utf8mb4_bin; insert into t values (1, 'xyz mnt'), (2, 'xyz mnt'), (3, 'xyz'); select * from t where match(contents) against ('xyz mnt' in boolean mode) limit 1; FTS_DOC_ID contents 1 xyz mnt select * from t where match(contents) against ('xyz mnt' in boolean mode) limit 2; FTS_DOC_ID contents 1 xyz mnt 2 xyz mnt select * from t where match(contents) against ('xyz mnt' in boolean mode) limit 3; FTS_DOC_ID contents 1 xyz mnt 2 xyz mnt 3 xyz select * from t where match(contents) against ('xyz mnt' in boolean mode) limit 4; FTS_DOC_ID contents 1 xyz mnt 2 xyz mnt 3 xyz select * from t where match(contents) against ('xyz mnt' in boolean mode) limit 5; FTS_DOC_ID contents 1 xyz mnt 2 xyz mnt 3 xyz select * from t WHERE match(contents) against ('xyz mnt' in boolean mode) limit 6; FTS_DOC_ID contents 1 xyz mnt 2 xyz mnt 3 xyz DROP TABLE t;