· 6 years ago · Aug 05, 2019, 11:28 PM
1root@LAPTOP-U6EJ8KII:~/DBA# cat stuff.txt
2a's able about above according
3accordingly across actually after afterwards
4again against ain't all allow
5allows almost alone along already
6also although always am among
7amongst an and another any
8anybody anyhow anyone anything anyway
9anyways anywhere apart appear appreciate
10appropriate are aren't around as
11aside ask asking associated at
12available away awfully be became
13because become becomes becoming been
14before beforehand behind being believe
15below beside besides best better
16between beyond both brief but
17by c'mon c's came can
18can't cannot cant cause causes
19certain certainly changes clearly co
20com come comes concerning consequently
21consider considering contain containing contains
22corresponding could couldn't course currently
23definitely described despite did didn't
24different do does doesn't doing
25don't done down downwards during
26each edu eg eight either
27else elsewhere enough entirely especially
28et etc even ever every
29everybody everyone everything everywhere ex
30exactly example except far few
31fifth first five followed following
32follows for former formerly forth
33four from further furthermore get
34gets getting given gives go
35goes going gone got gotten
36greetings had hadn't happens hardly
37has hasn't have haven't having
38he he's hello help hence
39her here here's hereafter hereby
40herein hereupon hers herself hi
41him himself his hither hopefully
42how howbeit however i'd i'll
43i'm i've ie if ignored
44immediate in inasmuch inc indeed
45indicate indicated indicates inner insofar
46instead into inward is isn't
47it it'd it'll it's its
48itself just keep keeps kept
49know known knows last lately
50later latter latterly least less
51lest let let's like liked
52likely little look looking looks
53ltd mainly many may maybe
54me mean meanwhile merely might
55more moreover most mostly much
56must my myself name namely
57nd near nearly necessary need
58needs neither never nevertheless new
59next nine no nobody non
60none noone nor normally not
61nothing novel now nowhere obviously
62of off often oh ok
63okay old on once one
64ones only onto or other
65others otherwise ought our ours
66ourselves out outside over overall
67own particular particularly per perhaps
68placed please plus possible presumably
69probably provides que quite qv
70rather rd re really reasonably
71regarding regardless regards relatively respectively
72right said same saw say
73saying says second secondly see
74seeing seem seemed seeming seems
75seen self selves sensible sent
76serious seriously seven several shall
77she should shouldn't since six
78so some somebody somehow someone
79something sometime sometimes somewhat somewhere
80soon sorry specified specify specifying
81still sub such sup sure
82t's take taken tell tends
83th than thank thanks thanx
84that that's thats the their
85theirs them themselves then thence
86there there's thereafter thereby therefore
87therein theres thereupon these they
88they'd they'll they're they've think
89third this thorough thoroughly those
90though three through throughout thru
91thus to together too took
92toward towards tried tries truly
93try trying twice two un
94under unfortunately unless unlikely until
95unto up upon us use
96used useful uses using usually
97value various very via viz
98vs want wants was wasn't
99way we we'd we'll we're
100we've welcome well went were
101weren't what what's whatever when
102whence whenever where where's whereafter
103whereas whereby wherein whereupon wherever
104whether which while whither who
105who's whoever whole whom whose
106why will willing wish with
107within without won't wonder would
108wouldn't yes yet you you'd
109you'll you're you've your yours
110yourself yourselves zero
111root@LAPTOP-U6EJ8KII:~/DBA#
112
113root@LAPTOP-U6EJ8KII:~/DBA# for TAG in `cat stuff.txt` ; do echo ${TAG}; done > stopwords_table.sql
114
115root@LAPTOP-U6EJ8KII:~/DBA# cat stopwords_table.sql
116DROP DATABASe IF EXISTS cust_stop;
117CREATE DATABASE cust_stop;
118USE cust_stop
119CREATE TABLE stopwords (VALUE VARCHAR(20)) ENGINE=InnoDB;
120INSERT INTO stopwords (VALUE) VALUES
121('a''s'),
122('able'),
123('about'),
124('above'),
125('according'),
126('accordingly'),
127('across'),
128('actually'),
129('after'),
130('afterwards'),
131('again'),
132('against'),
133('ain''t'),
134('all'),
135('allow'),
136('allows'),
137('almost'),
138('alone'),
139('along'),
140('already'),
141('also'),
142('although'),
143('always'),
144('am'),
145('among'),
146('amongst'),
147('an'),
148('and'),
149('another'),
150('any'),
151('anybody'),
152('anyhow'),
153('anyone'),
154('anything'),
155('anyway'),
156('anyways'),
157('anywhere'),
158('apart'),
159('appear'),
160('appreciate'),
161('appropriate'),
162('are'),
163('aren''t'),
164('around'),
165('as'),
166('aside'),
167('ask'),
168('asking'),
169('associated'),
170('at'),
171('available'),
172('away'),
173('awfully'),
174('be'),
175('became'),
176('because'),
177('become'),
178('becomes'),
179('becoming'),
180('been'),
181('before'),
182('beforehand'),
183('behind'),
184('being'),
185('believe'),
186('below'),
187('beside'),
188('besides'),
189('best'),
190('better'),
191('between'),
192('beyond'),
193('both'),
194('brief'),
195('but'),
196('by'),
197('c''mon'),
198('c''s'),
199('came'),
200('can'),
201('can''t'),
202('cannot'),
203('cant'),
204('cause'),
205('causes'),
206('certain'),
207('certainly'),
208('changes'),
209('clearly'),
210('co'),
211('com'),
212('come'),
213('comes'),
214('concerning'),
215('consequently'),
216('consider'),
217('considering'),
218('contain'),
219('containing'),
220('contains'),
221('corresponding'),
222('could'),
223('couldn''t'),
224('course'),
225('currently'),
226('definitely'),
227('described'),
228('despite'),
229('did'),
230('didn''t'),
231('different'),
232('do'),
233('does'),
234('doesn''t'),
235('doing'),
236('don''t'),
237('done'),
238('down'),
239('downwards'),
240('during'),
241('each'),
242('edu'),
243('eg'),
244('eight'),
245('either'),
246('else'),
247('elsewhere'),
248('enough'),
249('entirely'),
250('especially'),
251('et'),
252('etc'),
253('even'),
254('ever'),
255('every'),
256('everybody'),
257('everyone'),
258('everything'),
259('everywhere'),
260('ex'),
261('exactly'),
262('example'),
263('except'),
264('far'),
265('few'),
266('fifth'),
267('first'),
268('five'),
269('followed'),
270('following'),
271('follows'),
272('for'),
273('former'),
274('formerly'),
275('forth'),
276('four'),
277('from'),
278('further'),
279('furthermore'),
280('get'),
281('gets'),
282('getting'),
283('given'),
284('gives'),
285('go'),
286('goes'),
287('going'),
288('gone'),
289('got'),
290('gotten'),
291('greetings'),
292('had'),
293('hadn''t'),
294('happens'),
295('hardly'),
296('has'),
297('hasn''t'),
298('have'),
299('haven''t'),
300('having'),
301('he'),
302('he''s'),
303('hello'),
304('help'),
305('hence'),
306('her'),
307('here'),
308('here''s'),
309('hereafter'),
310('hereby'),
311('herein'),
312('hereupon'),
313('hers'),
314('herself'),
315('hi'),
316('him'),
317('himself'),
318('his'),
319('hither'),
320('hopefully'),
321('how'),
322('howbeit'),
323('however'),
324('i''d'),
325('i''ll'),
326('i''m'),
327('i''ve'),
328('ie'),
329('if'),
330('ignored'),
331('immediate'),
332('in'),
333('inasmuch'),
334('inc'),
335('indeed'),
336('indicate'),
337('indicated'),
338('indicates'),
339('inner'),
340('insofar'),
341('instead'),
342('into'),
343('inward'),
344('is'),
345('isn''t'),
346('it'),
347('it''d'),
348('it''ll'),
349('it''s'),
350('its'),
351('itself'),
352('just'),
353('keep'),
354('keeps'),
355('kept'),
356('know'),
357('known'),
358('knows'),
359('last'),
360('lately'),
361('later'),
362('latter'),
363('latterly'),
364('least'),
365('less'),
366('lest'),
367('let'),
368('let''s'),
369('like'),
370('liked'),
371('likely'),
372('little'),
373('look'),
374('looking'),
375('looks'),
376('ltd'),
377('mainly'),
378('many'),
379('may'),
380('maybe'),
381('me'),
382('mean'),
383('meanwhile'),
384('merely'),
385('might'),
386('more'),
387('moreover'),
388('most'),
389('mostly'),
390('much'),
391('must'),
392('my'),
393('myself'),
394('name'),
395('namely'),
396('nd'),
397('near'),
398('nearly'),
399('necessary'),
400('need'),
401('needs'),
402('neither'),
403('never'),
404('nevertheless'),
405('new'),
406('next'),
407('nine'),
408('no'),
409('nobody'),
410('non'),
411('none'),
412('noone'),
413('nor'),
414('normally'),
415('not'),
416('nothing'),
417('novel'),
418('now'),
419('nowhere'),
420('obviously'),
421('of'),
422('off'),
423('often'),
424('oh'),
425('ok'),
426('okay'),
427('old'),
428('on'),
429('once'),
430('one'),
431('ones'),
432('only'),
433('onto'),
434('or'),
435('other'),
436('others'),
437('otherwise'),
438('ought'),
439('our'),
440('ours'),
441('ourselves'),
442('out'),
443('outside'),
444('over'),
445('overall'),
446('own'),
447('particular'),
448('particularly'),
449('per'),
450('perhaps'),
451('placed'),
452('please'),
453('plus'),
454('possible'),
455('presumably'),
456('probably'),
457('provides'),
458('que'),
459('quite'),
460('qv'),
461('rather'),
462('rd'),
463('re'),
464('really'),
465('reasonably'),
466('regarding'),
467('regardless'),
468('regards'),
469('relatively'),
470('respectively'),
471('right'),
472('said'),
473('same'),
474('saw'),
475('say'),
476('saying'),
477('says'),
478('second'),
479('secondly'),
480('see'),
481('seeing'),
482('seem'),
483('seemed'),
484('seeming'),
485('seems'),
486('seen'),
487('self'),
488('selves'),
489('sensible'),
490('sent'),
491('serious'),
492('seriously'),
493('seven'),
494('several'),
495('shall'),
496('she'),
497('should'),
498('shouldn''t'),
499('since'),
500('six'),
501('so'),
502('some'),
503('somebody'),
504('somehow'),
505('someone'),
506('something'),
507('sometime'),
508('sometimes'),
509('somewhat'),
510('somewhere'),
511('soon'),
512('sorry'),
513('specified'),
514('specify'),
515('specifying'),
516('still'),
517('sub'),
518('such'),
519('sup'),
520('sure'),
521('t''s'),
522('take'),
523('taken'),
524('tell'),
525('tends'),
526('th'),
527('than'),
528('thank'),
529('thanks'),
530('thanx'),
531('that'),
532('that''s'),
533('thats'),
534('the'),
535('their'),
536('theirs'),
537('them'),
538('themselves'),
539('then'),
540('thence'),
541('there'),
542('there''s'),
543('thereafter'),
544('thereby'),
545('therefore'),
546('therein'),
547('theres'),
548('thereupon'),
549('these'),
550('they'),
551('they''d'),
552('they''ll'),
553('they''re'),
554('they''ve'),
555('think'),
556('third'),
557('this'),
558('thorough'),
559('thoroughly'),
560('those'),
561('though'),
562('three'),
563('through'),
564('throughout'),
565('thru'),
566('thus'),
567('to'),
568('together'),
569('too'),
570('took'),
571('toward'),
572('towards'),
573('tried'),
574('tries'),
575('truly'),
576('try'),
577('trying'),
578('twice'),
579('two'),
580('un'),
581('under'),
582('unfortunately'),
583('unless'),
584('unlikely'),
585('until'),
586('unto'),
587('up'),
588('upon'),
589('us'),
590('use'),
591('used'),
592('useful'),
593('uses'),
594('using'),
595('usually'),
596('value'),
597('various'),
598('very'),
599('via'),
600('viz'),
601('vs'),
602('want'),
603('wants'),
604('was'),
605('wasn''t'),
606('way'),
607('we'),
608('we''d'),
609('we''ll'),
610('we''re'),
611('we''ve'),
612('welcome'),
613('well'),
614('went'),
615('were'),
616('weren''t'),
617('what'),
618('what''s'),
619('whatever'),
620('when'),
621('whence'),
622('whenever'),
623('where'),
624('where''s'),
625('whereafter'),
626('whereas'),
627('whereby'),
628('wherein'),
629('whereupon'),
630('wherever'),
631('whether'),
632('which'),
633('while'),
634('whither'),
635('who'),
636('who''s'),
637('whoever'),
638('whole'),
639('whom'),
640('whose'),
641('why'),
642('will'),
643('willing'),
644('wish'),
645('with'),
646('within'),
647('without'),
648('won''t'),
649('wonder'),
650('would'),
651('wouldn''t'),
652('yes'),
653('yet'),
654('you'),
655('you''d'),
656('you''ll'),
657('you''re'),
658('you''ve'),
659('your'),
660('yours'),
661('yourself'),
662('yourselves'),
663('zero');
664
665root@LAPTOP-U6EJ8KII:~/DBA#
666
667innodb_ft_server_stopword_table=cust_stop/stopwords