MySQL InnoDB / MyISAM 預設的英文停用字清單

MySQL 5.7 後,InnoDB 也支援 FULLTEXT Search 了。

  • 詳見:13.9 Full-Text Search Functions
    • Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.
    • Full-text indexes 只能用在 InnoDB / MyISAM,欄位格式支援:CHARVARCHARTEXT

InnoDB 和 MyISAM 在系統內建的停用字清單分別是哪些字?如何指定自己的停用字清單?

MySQL InnoDB / MyISAM 預設的英文停用字清單

InnoDB 的停用字清單 與 自己設定的方法

InnoDB 想要自己指定 Stop words 可見:15.12 InnoDB Startup Options and System Variables --innodbftserverstopwordtable=dbname/tablename

InnoDB 建立自己的停用字 Table 步驟

  • 下述摘錄自此篇:13.9.4 Full-Text Stopwords
    1. mysql> use test
    2. mysql> CREATE TABLE mystopwords(value VARCHAR(30)) ENGINE = INNODB;
      -- Insert stopwords (for simplicity, a single stopword is used in this example)
    3. mysql> INSERT INTO mystopwords(value) VALUES ('Ishmael');
    4. mysql> SET GLOBAL innodbftserverstopwordtable = 'test/mystopwords';
      -- CREATE FULLTEXT INDEX idx ON table
      name(colnum_name);

MyISAM 的停用字清單 與 自己設定的方法

  • MyISAM 的 Stop words (storage/myisam/ft_static.c)
    • a's
    • able
    • about
    • above
    • according
    • accordingly
    • across
    • actually
    • after
    • afterwards
    • again
    • against
    • ain't
    • all
    • allow
    • allows
    • almost
    • alone
    • along
    • already
    • also
    • although
    • always
    • am
    • among
    • amongst
    • an
    • and
    • another
    • any
    • anybody
    • anyhow
    • anyone
    • anything
    • anyway
    • anyways
    • anywhere
    • apart
    • appear
    • appreciate
    • appropriate
    • are
    • aren't
    • around
    • as
    • aside
    • ask
    • asking
    • associated
    • at
    • available
    • away
    • awfully
    • be
    • became
    • because
    • become
    • becomes
    • becoming
    • been
    • before
    • beforehand
    • behind
    • being
    • believe
    • below
    • beside
    • besides
    • best
    • better
    • between
    • beyond
    • both
    • brief
    • but
    • by
    • c'mon
    • c's
    • came
    • can
    • can't
    • cannot
    • cant
    • cause
    • causes
    • certain
    • certainly
    • changes
    • clearly
    • co
    • com
    • come
    • comes
    • concerning
    • consequently
    • consider
    • considering
    • contain
    • containing
    • contains
    • corresponding
    • could
    • couldn't
    • course
    • currently
    • definitely
    • described
    • despite
    • did
    • didn't
    • different
    • do
    • does
    • doesn't
    • doing
    • don't
    • done
    • down
    • downwards
    • during
    • each
    • edu
    • eg
    • eight
    • either
    • else
    • elsewhere
    • enough
    • entirely
    • especially
    • et
    • etc
    • even
    • ever
    • every
    • everybody
    • everyone
    • everything
    • everywhere
    • ex
    • exactly
    • example
    • except
    • far
    • few
    • fifth
    • first
    • five
    • followed
    • following
    • follows
    • for
    • former
    • formerly
    • forth
    • four
    • from
    • further
    • furthermore
    • get
    • gets
    • getting
    • given
    • gives
    • go
    • goes
    • going
    • gone
    • got
    • gotten
    • greetings
    • had
    • hadn't
    • happens
    • hardly
    • has
    • hasn't
    • have
    • haven't
    • having
    • he
    • he's
    • hello
    • help
    • hence
    • her
    • here
    • here's
    • hereafter
    • hereby
    • herein
    • hereupon
    • hers
    • herself
    • hi
    • him
    • himself
    • his
    • hither
    • hopefully
    • how
    • howbeit
    • however
    • i'd
    • i'll
    • i'm
    • i've
    • ie
    • if
    • ignored
    • immediate
    • in
    • inasmuch
    • inc
    • indeed
    • indicate
    • indicated
    • indicates
    • inner
    • insofar
    • instead
    • into
    • inward
    • is
    • isn't
    • it
    • it'd
    • it'll
    • it's
    • its
    • itself
    • just
    • keep
    • keeps
    • kept
    • know
    • known
    • knows
    • last
    • lately
    • later
    • latter
    • latterly
    • least
    • less
    • lest
    • let
    • let's
    • like
    • liked
    • likely
    • little
    • look
    • looking
    • looks
    • ltd
    • mainly
    • many
    • may
    • maybe
    • me
    • mean
    • meanwhile
    • merely
    • might
    • more
    • moreover
    • most
    • mostly
    • much
    • must
    • my
    • myself
    • name
    • namely
    • nd
    • near
    • nearly
    • necessary
    • need
    • needs
    • neither
    • never
    • nevertheless
    • new
    • next
    • nine
    • no
    • nobody
    • non
    • none
    • noone
    • nor
    • normally
    • not
    • nothing
    • novel
    • now
    • nowhere
    • obviously
    • of
    • off
    • often
    • oh
    • ok
    • okay
    • old
    • on
    • once
    • one
    • ones
    • only
    • onto
    • or
    • other
    • others
    • otherwise
    • ought
    • our
    • ours
    • ourselves
    • out
    • outside
    • over
    • overall
    • own
    • particular
    • particularly
    • per
    • perhaps
    • placed
    • please
    • plus
    • possible
    • presumably
    • probably
    • provides
    • que
    • quite
    • qv
    • rather
    • rd
    • re
    • really
    • reasonably
    • regarding
    • regardless
    • regards
    • relatively
    • respectively
    • right
    • said
    • same
    • saw
    • say
    • saying
    • says
    • second
    • secondly
    • see
    • seeing
    • seem
    • seemed
    • seeming
    • seems
    • seen
    • self
    • selves
    • sensible
    • sent
    • serious
    • seriously
    • seven
    • several
    • shall
    • she
    • should
    • shouldn't
    • since
    • six
    • so
    • some
    • somebody
    • somehow
    • someone
    • something
    • sometime
    • sometimes
    • somewhat
    • somewhere
    • soon
    • sorry
    • specified
    • specify
    • specifying
    • still
    • sub
    • such
    • sup
    • sure
    • t's
    • take
    • taken
    • tell
    • tends
    • th
    • than
    • thank
    • thanks
    • thanx
    • that
    • that's
    • thats
    • the
    • their
    • theirs
    • them
    • themselves
    • then
    • thence
    • there
    • there's
    • thereafter
    • thereby
    • therefore
    • therein
    • theres
    • thereupon
    • these
    • they
    • they'd
    • they'll
    • they're
    • they've
    • think
    • third
    • this
    • thorough
    • thoroughly
    • those
    • though
    • three
    • through
    • throughout
    • thru
    • thus
    • to
    • together
    • too
    • took
    • toward
    • towards
    • tried
    • tries
    • truly
    • try
    • trying
    • twice
    • two
    • un
    • under
    • unfortunately
    • unless
    • unlikely
    • until
    • unto
    • up
    • upon
    • us
    • use
    • used
    • useful
    • uses
    • using
    • usually
    • value
    • various
    • very
    • via
    • viz
    • vs
    • want
    • wants
    • was
    • wasn't
    • way
    • we
    • we'd
    • we'll
    • we're
    • we've
    • welcome
    • well
    • went
    • were
    • weren't
    • what
    • what's
    • whatever
    • when
    • whence
    • whenever
    • where
    • where's
    • whereafter
    • whereas
    • whereby
    • wherein
    • whereupon
    • wherever
    • whether
    • which
    • while
    • whither
    • who
    • who's
    • whoever
    • whole
    • whom
    • whose
    • why
    • will
    • willing
    • wish
    • with
    • within
    • without
    • won't
    • wonder
    • would
    • wouldn't
    • yes
    • yet
    • you
    • you'd
    • you'll
    • you're
    • you've
    • your
    • yours
    • yourself
    • yourselves
    • zero

MyISAM 想要另外指定 stop word file 可見:6.1.4 Server System Variables --ftstopwordfile=file_name

作者: Tsung

對新奇的事物都很有興趣, 喜歡簡單的東西, 過簡單的生活.

發表迴響

這個網站採用 Akismet 服務減少垃圾留言。進一步了解 Akismet 如何處理網站訪客的留言資料