1drop table if exists t1;
2CREATE TABLE t1 (
3id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4a VARCHAR(200),
5b TEXT
6) ENGINE = InnoDB STATS_PERSISTENT=0;
7CREATE FULLTEXT INDEX idx on t1 (a,b);
8Warnings:
9Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
10INSERT INTO t1 (a,b) VALUES
11('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
12('when To Use MySQL Well','After that you went through a ...'),
13('where will Optimizing MySQL','what In this tutorial we will show ...');
14START TRANSACTION;
15INSERT INTO t1 (a,b) VALUES
16('MySQL Tutorial','request docteam for oraclehelp.');
17SELECT * FROM t1
18WHERE MATCH (a,b)
19AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
20id	a	b
211	MySQL from Tutorial	DBMS stands for DataBase ...
223	where will Optimizing MySQL	what In this tutorial we will show ...
23SELECT * FROM t1
24WHERE MATCH (a,b)
25AGAINST ('request' IN NATURAL LANGUAGE MODE);
26id	a	b
27SELECT * FROM t1
28WHERE MATCH (a,b)
29AGAINST ('request MySQL' IN BOOLEAN MODE);
30id	a	b
311	MySQL from Tutorial	DBMS stands for DataBase ...
322	when To Use MySQL Well	After that you went through a ...
333	where will Optimizing MySQL	what In this tutorial we will show ...
34SELECT * FROM t1
35WHERE MATCH (a,b)
36AGAINST ('-request +MySQL' IN BOOLEAN MODE);
37id	a	b
381	MySQL from Tutorial	DBMS stands for DataBase ...
392	when To Use MySQL Well	After that you went through a ...
403	where will Optimizing MySQL	what In this tutorial we will show ...
41SELECT * FROM t1
42WHERE MATCH (a,b)
43AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
44id	a	b
452	when To Use MySQL Well	After that you went through a ...
46SELECT * FROM t1
47WHERE MATCH (a,b)
48AGAINST ('"stands Database"@11' IN BOOLEAN MODE) ORDER BY 1;
49id	a	b
501	MySQL from Tutorial	DBMS stands for DataBase ...
51SELECT * FROM t1
52WHERE MATCH (a,b)
53AGAINST ('tutorial' WITH QUERY EXPANSION);
54id	a	b
551	MySQL from Tutorial	DBMS stands for DataBase ...
563	where will Optimizing MySQL	what In this tutorial we will show ...
572	when To Use MySQL Well	After that you went through a ...
58COMMIT;
59SELECT * FROM t1
60WHERE MATCH (a,b)
61AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
62id	a	b
631	MySQL from Tutorial	DBMS stands for DataBase ...
643	where will Optimizing MySQL	what In this tutorial we will show ...
654	MySQL Tutorial	request docteam for oraclehelp.
66SELECT * FROM t1
67WHERE MATCH (a,b)
68AGAINST ('request MySQL' IN BOOLEAN MODE);
69id	a	b
704	MySQL Tutorial	request docteam for oraclehelp.
711	MySQL from Tutorial	DBMS stands for DataBase ...
722	when To Use MySQL Well	After that you went through a ...
733	where will Optimizing MySQL	what In this tutorial we will show ...
74SELECT * FROM t1
75WHERE MATCH (a,b)
76AGAINST ('tutorial' WITH QUERY EXPANSION);
77id	a	b
781	MySQL from Tutorial	DBMS stands for DataBase ...
794	MySQL Tutorial	request docteam for oraclehelp.
803	where will Optimizing MySQL	what In this tutorial we will show ...
812	when To Use MySQL Well	After that you went through a ...
82START TRANSACTION;
83INSERT INTO t1 (a,b) VALUES (NULL,NULL);
84SELECT * FROM t1
85WHERE MATCH (a,b)
86AGAINST ('+request +MySQL' IN BOOLEAN MODE);
87id	a	b
884	MySQL Tutorial	request docteam for oraclehelp.
89UPDATE t1 SET a = 'Trial version' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...'
90WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
91SELECT * FROM t1
92WHERE MATCH (a,b)
93AGAINST ('request');
94id	a	b
95SELECT * FROM t1
96WHERE MATCH (a,b)
97AGAINST ('query performace' IN BOOLEAN MODE);
98id	a	b
99UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq  xyz.com ...'
100WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
101SELECT * FROM t1
102WHERE MATCH (a,b)
103AGAINST ('performace');
104id	a	b
105SELECT * FROM t1
106WHERE MATCH (a,b)
107AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
108id	a	b
109COMMIT;
110DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
111SELECT * FROM t1;
112id	a	b
1134	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
1145	NULL	NULL
115INSERT INTO t1 (a,b) VALUES
116('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...')  ,
117('when To Use MySQL Well','for free faq  mail@xyz.com ...');
118SELECT * FROM t1;
119id	a	b
1204	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
1215	NULL	NULL
1226	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
1237	when To Use MySQL Well	for free faq  mail@xyz.com ...
124DROP TABLE t1;
125CREATE TABLE t1 (
126id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
127a VARCHAR(200),
128b TEXT
129) ENGINE = InnoDB;
130CREATE FULLTEXT INDEX idx on t1 (a,b);
131Warnings:
132Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
133INSERT INTO t1 (a,b) VALUES
134('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
135('when To Use MySQL Well','After that you went through a ...'),
136('where will Optimizing MySQL','what In this tutorial we will show ...');
137START TRANSACTION;
138INSERT INTO t1 (a,b) VALUES
139('MySQL Tutorial','request docteam for oraclehelp.');
140SELECT * FROM t1
141WHERE MATCH (a,b)
142AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
143id	a	b
1441	MySQL from Tutorial	DBMS stands for DataBase ...
1453	where will Optimizing MySQL	what In this tutorial we will show ...
146SELECT * FROM t1
147WHERE MATCH (a,b)
148AGAINST ('request' IN NATURAL LANGUAGE MODE);
149id	a	b
150SELECT * FROM t1
151WHERE MATCH (a,b)
152AGAINST ('request MySQL' IN BOOLEAN MODE);
153id	a	b
1541	MySQL from Tutorial	DBMS stands for DataBase ...
1552	when To Use MySQL Well	After that you went through a ...
1563	where will Optimizing MySQL	what In this tutorial we will show ...
157SELECT * FROM t1
158WHERE MATCH (a,b)
159AGAINST ('-request +MySQL' IN BOOLEAN MODE);
160id	a	b
1611	MySQL from Tutorial	DBMS stands for DataBase ...
1622	when To Use MySQL Well	After that you went through a ...
1633	where will Optimizing MySQL	what In this tutorial we will show ...
164SELECT * FROM t1
165WHERE MATCH (a,b)
166AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
167id	a	b
1682	when To Use MySQL Well	After that you went through a ...
169SELECT * FROM t1
170WHERE MATCH (a,b)
171AGAINST ('tutorial' WITH QUERY EXPANSION);
172id	a	b
1731	MySQL from Tutorial	DBMS stands for DataBase ...
1743	where will Optimizing MySQL	what In this tutorial we will show ...
1752	when To Use MySQL Well	After that you went through a ...
176SELECT * FROM t1
177WHERE MATCH (a,b)
178AGAINST ('tutorial' WITH QUERY EXPANSION);
179id	a	b
1801	MySQL from Tutorial	DBMS stands for DataBase ...
1813	where will Optimizing MySQL	what In this tutorial we will show ...
1822	when To Use MySQL Well	After that you went through a ...
183ROLLBACK;
184SELECT * FROM t1
185WHERE MATCH (a,b)
186AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
187id	a	b
1881	MySQL from Tutorial	DBMS stands for DataBase ...
1893	where will Optimizing MySQL	what In this tutorial we will show ...
190SELECT * FROM t1
191WHERE MATCH (a,b)
192AGAINST ('request MySQL' IN BOOLEAN MODE);
193id	a	b
1941	MySQL from Tutorial	DBMS stands for DataBase ...
1952	when To Use MySQL Well	After that you went through a ...
1963	where will Optimizing MySQL	what In this tutorial we will show ...
197SELECT * FROM t1
198WHERE MATCH (a,b)
199AGAINST ('tutorial' WITH QUERY EXPANSION);
200id	a	b
2011	MySQL from Tutorial	DBMS stands for DataBase ...
2023	where will Optimizing MySQL	what In this tutorial we will show ...
2032	when To Use MySQL Well	After that you went through a ...
204START TRANSACTION;
205INSERT INTO t1 (a,b) VALUES (NULL,NULL);
206UPDATE t1 SET a = 'Trial version' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...'
207WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
208SELECT * FROM t1
209WHERE MATCH (a,b)
210AGAINST ('request');
211id	a	b
212SELECT * FROM t1
213WHERE MATCH (a,b)
214AGAINST ('query performace' IN BOOLEAN MODE);
215id	a	b
216UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq  xyz.com ...'
217WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
218SELECT * FROM t1
219WHERE MATCH (a,b)
220AGAINST ('performace');
221id	a	b
222SELECT * FROM t1
223WHERE MATCH (a,b)
224AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
225id	a	b
226ROLLBACK;
227DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
228SELECT * FROM t1;
229id	a	b
230INSERT INTO t1 (a,b) VALUES
231('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...')  ,
232('when To Use MySQL Well','for free faq  mail@xyz.com ...');
233SELECT * FROM t1;
234id	a	b
2356	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
2367	when To Use MySQL Well	for free faq  mail@xyz.com ...
237DROP TABLE t1;
238CREATE TABLE t1 (
239id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
240a VARCHAR(200),
241b TEXT
242) ENGINE = InnoDB;
243CREATE FULLTEXT INDEX idx on t1 (a,b);
244Warnings:
245Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
246INSERT INTO t1 (a,b) VALUES
247('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
248('when To Use MySQL Well','After that you went through a ...'),
249('where will Optimizing MySQL','what In this tutorial we will show ...');
250INSERT INTO t1 (a,b) VALUES
251('MySQL Tutorial','request docteam for oraclehelp.');
252START TRANSACTION;
253INSERT INTO t1 (a,b) VALUES (NULL,NULL);
254SELECT * FROM t1
255WHERE MATCH (a,b)
256AGAINST ('+request +MySQL' IN BOOLEAN MODE);
257id	a	b
2584	MySQL Tutorial	request docteam for oraclehelp.
259UPDATE t1 SET a = 'Trial version' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...' WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
260SELECT * from t1;
261id	a	b
2621	MySQL from Tutorial	DBMS stands for DataBase ...
2632	when To Use MySQL Well	After that you went through a ...
2643	where will Optimizing MySQL	what In this tutorial we will show ...
2654	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
2665	NULL	NULL
267SELECT * FROM t1
268WHERE MATCH (a,b)
269AGAINST ('request');
270id	a	b
271SELECT * FROM t1
272WHERE MATCH (a,b)
273AGAINST ('query performace' IN BOOLEAN MODE);
274id	a	b
275UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq mail xyz.com ...' WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
276UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq mail xyz.com ...' WHERE b like '%query performace%';
277SELECT * FROM t1
278WHERE MATCH (a,b)
279AGAINST ('performace');
280id	a	b
281SELECT * FROM t1
282WHERE MATCH (a,b)
283AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
284id	a	b
285SELECT * from t1;
286id	a	b
2871	MySQL from Tutorial	DBMS stands for DataBase ...
2882	when To Use MySQL Well	After that you went through a ...
2893	where will Optimizing MySQL	what In this tutorial we will show ...
2904	when To Use MySQL Well	for free faq mail xyz.com ...
2915	NULL	NULL
292COMMIT;
293SELECT * from t1;
294id	a	b
2951	MySQL from Tutorial	DBMS stands for DataBase ...
2962	when To Use MySQL Well	After that you went through a ...
2973	where will Optimizing MySQL	what In this tutorial we will show ...
2984	when To Use MySQL Well	for free faq mail xyz.com ...
2995	NULL	NULL
300DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
301SELECT * FROM t1;
302id	a	b
3035	NULL	NULL
304INSERT INTO t1 (a,b) VALUES
305('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...')  ,
306('when To Use MySQL Well','for free faq  mail@xyz.com ...');
307SELECT * FROM t1;
308id	a	b
3095	NULL	NULL
3106	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
3117	when To Use MySQL Well	for free faq  mail@xyz.com ...
312DROP TABLE t1;
313SET NAMES UTF8;
314CREATE TABLE t1 (
315id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
316a VARCHAR(200),
317b TEXT
318) CHARACTER SET = UTF8,ENGINE = InnoDB;
319"In connection 1"
320SET NAMES UTF8;
321INSERT INTO t1 (a,b) VALUES
322('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
323('when To Use MySQL Well','After that you went through a ...'),
324('where will Optimizing MySQL','what In this tutorial we will show ...'),
325('Я могу есть стекло', 'оно мне Mне вредит'),
326('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
327('Sævör grét', 'áðan því úlpan var ónýt');
328"In connection 2"
329SET NAMES UTF8;
330CREATE FULLTEXT INDEX idx on t1 (a,b);
331Warnings:
332Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
333"In connection 1"
334SELECT * FROM t1
335WHERE MATCH (a,b)
336AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
337id	a	b
3381	MySQL from Tutorial	DBMS stands for DataBase ...
3393	where will Optimizing MySQL	what In this tutorial we will show ...
340INSERT INTO t1 (a,b) VALUES
341('adding record using session 1','for verifying multiple concurrent transactions'),
342('Мога да ям стъкло', 'то Mне ми вреди');
343SELECT * FROM t1
344WHERE MATCH (a,b)
345AGAINST ('+γυαλιὰ +χωρὶ*' IN BOOLEAN MODE);
346id	a	b
3475	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
348START TRANSACTION;
349INSERT INTO t1 (a,b) VALUES
350('MySQL Tutorial','request docteam for oraclehelp.'),
351('Příliš žluťoučký kůň', 'úpěl ďábelské kódy');
352SELECT * FROM t1
353WHERE MATCH (a,b)
354AGAINST ('request ďábelské' IN BOOLEAN MODE);
355id	a	b
356SELECT * FROM t1
357WHERE MATCH (a,b)
358AGAINST ('tutorial' WITH QUERY EXPANSION) ORDER BY 1;
359id	a	b
3601	MySQL from Tutorial	DBMS stands for DataBase ...
3612	when To Use MySQL Well	After that you went through a ...
3623	where will Optimizing MySQL	what In this tutorial we will show ...
363SELECT * FROM t1
364WHERE MATCH (a,b)
365AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
366id	a	b
3676	Sævör grét	áðan því úlpan var ónýt
368"In connection 2"
369SELECT * FROM t1
370WHERE MATCH (a,b)
371AGAINST ('+record +multiple' IN BOOLEAN MODE);
372id	a	b
3737	adding record using session 1	for verifying multiple concurrent transactions
374SELECT * FROM t1
375WHERE MATCH (a,b)
376AGAINST ('tutor* Sævö*' IN BOOLEAN MODE) ORDER BY 1;
377id	a	b
3781	MySQL from Tutorial	DBMS stands for DataBase ...
3793	where will Optimizing MySQL	what In this tutorial we will show ...
3806	Sævör grét	áðan því úlpan var ónýt
381SELECT * FROM t1
382WHERE MATCH (a,b)
383AGAINST ('usin* multipl*' IN BOOLEAN MODE);
384id	a	b
3857	adding record using session 1	for verifying multiple concurrent transactions
386SELECT * FROM t1
387WHERE MATCH (a,b)
388AGAINST ('"request docteam"@08' IN BOOLEAN MODE);
389id	a	b
390SELECT * FROM t1
391WHERE MATCH (a,b)
392AGAINST ('request' IN NATURAL LANGUAGE MODE);
393id	a	b
394SELECT * FROM t1
395WHERE MATCH (a,b)
396AGAINST ('request MySQL' IN BOOLEAN MODE);
397id	a	b
3981	MySQL from Tutorial	DBMS stands for DataBase ...
3992	when To Use MySQL Well	After that you went through a ...
4003	where will Optimizing MySQL	what In this tutorial we will show ...
401SELECT * FROM t1
402WHERE MATCH (a,b)
403AGAINST ('-request +MySQL' IN BOOLEAN MODE);
404id	a	b
4051	MySQL from Tutorial	DBMS stands for DataBase ...
4062	when To Use MySQL Well	After that you went through a ...
4073	where will Optimizing MySQL	what In this tutorial we will show ...
408SELECT * FROM t1
409WHERE MATCH (a,b)
410AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
411id	a	b
4122	when To Use MySQL Well	After that you went through a ...
413SELECT * FROM t1
414WHERE MATCH (a,b)
415AGAINST ('"stands Database"@11' IN BOOLEAN MODE) ORDER BY 1;
416id	a	b
4171	MySQL from Tutorial	DBMS stands for DataBase ...
418SELECT * FROM t1
419WHERE MATCH (a,b)
420AGAINST ('tutorial' WITH QUERY EXPANSION) ORDER BY 1;
421id	a	b
4221	MySQL from Tutorial	DBMS stands for DataBase ...
4232	when To Use MySQL Well	After that you went through a ...
4243	where will Optimizing MySQL	what In this tutorial we will show ...
425"In connection 1"
426COMMIT;
427SELECT * FROM t1
428WHERE MATCH (a,b)
429AGAINST ('+request +MySQL' IN BOOLEAN MODE);
430id	a	b
4319	MySQL Tutorial	request docteam for oraclehelp.
432SELECT * FROM t1
433WHERE MATCH (a,b)
434AGAINST ('Příliš žluťoučký' IN BOOLEAN MODE);
435id	a	b
43610	Příliš žluťoučký kůň	úpěl ďábelské kódy
437SELECT * FROM t1
438WHERE MATCH (a,b)
439AGAINST ('Příliš');
440id	a	b
44110	Příliš žluťoučký kůň	úpěl ďábelské kódy
442INSERT INTO t1 (a,b) VALUES (NULL,NULL);
443SELECT * FROM t1 WHERE a IS NULL AND b IS NULL;
444id	a	b
44511	NULL	NULL
446"In connection 2"
447SELECT * FROM t1
448WHERE MATCH (a,b)
449AGAINST ('usin* multipl*' IN BOOLEAN MODE);
450id	a	b
4517	adding record using session 1	for verifying multiple concurrent transactions
452SELECT * FROM t1
453WHERE MATCH (a,b)
454AGAINST ('+request +MySQL' IN BOOLEAN MODE);
455id	a	b
4569	MySQL Tutorial	request docteam for oraclehelp.
457SELECT * FROM t1 WHERE a IS NULL AND b IS NULL;
458id	a	b
45911	NULL	NULL
460ALTER TABLE t1 DROP INDEX idx;
461CREATE FULLTEXT INDEX idx on t1 (a,b);
462START TRANSACTION;
463UPDATE t1 SET a = 'Trial version Příliš žluťoučký' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...'
464WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
465SELECT * FROM t1
466WHERE MATCH (a,b)
467AGAINST ('request');
468id	a	b
469SELECT * FROM t1
470WHERE MATCH (a,b)
471AGAINST ('+query +performace' IN BOOLEAN MODE);
472id	a	b
473UPDATE t1 SET a = UPPER(a) WHERE MATCH (a,b) AGAINST ('+Příliš +žluťoučký' IN BOOLEAN MODE);
474SELECT * FROM t1
475WHERE MATCH (a,b)
476AGAINST ('+Příliš +žluťoučký' IN BOOLEAN MODE);
477id	a	b
478UPDATE t1 SET a = UPPER(a) WHERE a LIKE '%version Příliš%';
479SELECT * FROM t1
480WHERE MATCH (a,b)
481AGAINST ('+query +performace' IN BOOLEAN MODE);
482id	a	b
483SELECT * FROM t1 WHERE b LIKE '%query performace%';
484id	a	b
4859	TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ	query performace 1255 minute on 2.1Hz Memory 2GB...
486SELECT * FROM t1
487WHERE MATCH (a,b)
488AGAINST ('request');
489id	a	b
490"In connection 1"
491SELECT * FROM t1
492WHERE MATCH (a,b)
493AGAINST ('query performace' IN BOOLEAN MODE);
494id	a	b
495SELECT * FROM t1
496WHERE MATCH (a,b)
497AGAINST ('performace');
498id	a	b
499SELECT * FROM t1
500WHERE MATCH (a,b)
501AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
502id	a	b
503"In connection 2"
504COMMIT;
505SELECT * FROM t1
506WHERE MATCH (a,b)
507AGAINST ('+query +performace' IN BOOLEAN MODE);
508id	a	b
5099	TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ	query performace 1255 minute on 2.1Hz Memory 2GB...
510"In connection 1"
511SELECT * FROM t1
512WHERE MATCH (a,b)
513AGAINST ('+query +performace' IN BOOLEAN MODE);
514id	a	b
5159	TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ	query performace 1255 minute on 2.1Hz Memory 2GB...
516UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq  xyz.com ...'
517WHERE MATCH (a,b) AGAINST ('+πάθω +τίποτα' IN BOOLEAN MODE);
518SELECT * FROM t1
519WHERE MATCH (a,b)
520AGAINST ('well free') ORDER BY 1;
521id	a	b
5222	when To Use MySQL Well	After that you went through a ...
5235	when To Use MySQL Well	for free faq  xyz.com ...
524DROP TABLE t1;
525SET NAMES UTF8;
526CREATE TABLE t1 (
527id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
528a VARCHAR(200),
529b TEXT
530) CHARACTER SET = UTF8,ENGINE = InnoDB;
531"In connection 1"
532SET NAMES UTF8;
533INSERT INTO t1 (a,b) VALUES
534('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
535('when To Use MySQL Well','After that you went through a ...'),
536('where will Optimizing MySQL','what In this tutorial we will show ...'),
537('Я могу есть стекло', 'оно мне Mне вредит'),
538('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
539('Sævör grét', 'áðan því úlpan var ónýt');
540"In connection 2"
541SET NAMES UTF8;
542select @@session.tx_isolation;
543@@session.tx_isolation
544REPEATABLE-READ
545Warnings:
546Warning	1287	'@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
547CREATE FULLTEXT INDEX idx on t1 (a,b);
548Warnings:
549Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
550INSERT INTO t1 (a,b) VALUES
551('adding record using session 1','for verifying multiple concurrent transactions'),
552('Мога да ям стъкло', 'то Mне ми вреди');
553"In connection 1"
554SELECT * FROM t1;
555id	a	b
5561	MySQL from Tutorial	DBMS stands for DataBase ...
5572	when To Use MySQL Well	After that you went through a ...
5583	where will Optimizing MySQL	what In this tutorial we will show ...
5594	Я могу есть стекло	оно мне Mне вредит
5605	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5616	Sævör grét	áðan því úlpan var ónýt
5627	adding record using session 1	for verifying multiple concurrent transactions
5638	Мога да ям стъкло	то Mне ми вреди
564START TRANSACTION;
565SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
566id	a	b
5678	Мога да ям стъкло	то Mне ми вреди
568DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
569DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
570SELECT * FROM t1;
571id	a	b
5721	MySQL from Tutorial	DBMS stands for DataBase ...
5732	when To Use MySQL Well	After that you went through a ...
5743	where will Optimizing MySQL	what In this tutorial we will show ...
5754	Я могу есть стекло	оно мне Mне вредит
5765	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5777	adding record using session 1	for verifying multiple concurrent transactions
578SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
579id	a	b
5804	Я могу есть стекло	оно мне Mне вредит
581SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
582id	a	b
5834	Я могу есть стекло	оно мне Mне вредит
584SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
585id	a	b
586SELECT * FROM t1;
587id	a	b
5881	MySQL from Tutorial	DBMS stands for DataBase ...
5892	when To Use MySQL Well	After that you went through a ...
5903	where will Optimizing MySQL	what In this tutorial we will show ...
5914	Я могу есть стекло	оно мне Mне вредит
5925	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5937	adding record using session 1	for verifying multiple concurrent transactions
594"In connection 2"
595SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
596id	a	b
5974	Я могу есть стекло	оно мне Mне вредит
5988	Мога да ям стъкло	то Mне ми вреди
599SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
600id	a	b
6014	Я могу есть стекло	оно мне Mне вредит
602SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
603id	a	b
6046	Sævör grét	áðan því úlpan var ónýt
605SELECT * FROM t1;
606id	a	b
6071	MySQL from Tutorial	DBMS stands for DataBase ...
6082	when To Use MySQL Well	After that you went through a ...
6093	where will Optimizing MySQL	what In this tutorial we will show ...
6104	Я могу есть стекло	оно мне Mне вредит
6115	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6126	Sævör grét	áðan því úlpan var ónýt
6137	adding record using session 1	for verifying multiple concurrent transactions
6148	Мога да ям стъкло	то Mне ми вреди
615"In connection 1"
616COMMIT;
617SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
618id	a	b
6194	Я могу есть стекло	оно мне Mне вредит
620SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
621id	a	b
6224	Я могу есть стекло	оно мне Mне вредит
623SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
624id	a	b
625"In connection 2"
626SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
627id	a	b
6284	Я могу есть стекло	оно мне Mне вредит
629SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
630id	a	b
6314	Я могу есть стекло	оно мне Mне вредит
632SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
633id	a	b
634SELECT * FROM t1;
635id	a	b
6361	MySQL from Tutorial	DBMS stands for DataBase ...
6372	when To Use MySQL Well	After that you went through a ...
6383	where will Optimizing MySQL	what In this tutorial we will show ...
6394	Я могу есть стекло	оно мне Mне вредит
6405	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6417	adding record using session 1	for verifying multiple concurrent transactions
642DROP TABLE t1;
643SET NAMES UTF8;
644CREATE TABLE t1 (
645id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
646a VARCHAR(200),
647b TEXT
648) CHARACTER SET = UTF8,ENGINE = InnoDB;
649"In connection 1"
650SET NAMES UTF8;
651INSERT INTO t1 (a,b) VALUES
652('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
653('when To Use MySQL Well','After that you went through a ...'),
654('where will Optimizing MySQL','what In this tutorial we will show ...'),
655('Я могу есть стекло', 'оно мне Mне вредит');
656"In connection 2"
657SET NAMES UTF8;
658select @@session.tx_isolation;
659@@session.tx_isolation
660REPEATABLE-READ
661Warnings:
662Warning	1287	'@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
663CREATE FULLTEXT INDEX idx on t1 (a,b);
664Warnings:
665Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
666INSERT INTO t1 (a,b) VALUES
667('adding record using session 1','for verifying multiple concurrent transactions'),
668('Мога да ям стъкло', 'то Mне ми вреди');
669"In connection 1"
670SELECT * FROM t1;
671id	a	b
6721	MySQL from Tutorial	DBMS stands for DataBase ...
6732	when To Use MySQL Well	After that you went through a ...
6743	where will Optimizing MySQL	what In this tutorial we will show ...
6754	Я могу есть стекло	оно мне Mне вредит
6765	adding record using session 1	for verifying multiple concurrent transactions
6776	Мога да ям стъкло	то Mне ми вреди
678START TRANSACTION;
679SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
680id	a	b
6816	Мога да ям стъкло	то Mне ми вреди
682UPDATE t1 SET a =  'Μπορῶ νὰ φάω σπασμένα' , b = 'γυαλιὰ χωρὶς νὰ πάθω τίποτα' WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
683INSERT INTO t1(a,b) VALUES ('Sævör grét', 'áðan því úlpan var ónýt');
684SELECT * FROM t1;
685id	a	b
6861	MySQL from Tutorial	DBMS stands for DataBase ...
6872	when To Use MySQL Well	After that you went through a ...
6883	where will Optimizing MySQL	what In this tutorial we will show ...
6894	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6905	adding record using session 1	for verifying multiple concurrent transactions
6916	Мога да ям стъкло	то Mне ми вреди
6927	Sævör grét	áðan því úlpan var ónýt
693SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
694id	a	b
6956	Мога да ям стъкло	то Mне ми вреди
696SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
697id	a	b
698SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
699id	a	b
7001	MySQL from Tutorial	DBMS stands for DataBase ...
701SELECT * FROM t1;
702id	a	b
7031	MySQL from Tutorial	DBMS stands for DataBase ...
7042	when To Use MySQL Well	After that you went through a ...
7053	where will Optimizing MySQL	what In this tutorial we will show ...
7064	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7075	adding record using session 1	for verifying multiple concurrent transactions
7086	Мога да ям стъкло	то Mне ми вреди
7097	Sævör grét	áðan því úlpan var ónýt
710"In connection 2"
711SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
712id	a	b
7134	Я могу есть стекло	оно мне Mне вредит
7146	Мога да ям стъкло	то Mне ми вреди
715SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
716id	a	b
7174	Я могу есть стекло	оно мне Mне вредит
718SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
719id	a	b
7201	MySQL from Tutorial	DBMS stands for DataBase ...
721SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
722SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
723id	a	b
7246	Мога да ям стъкло	то Mне ми вреди
725SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
726id	a	b
727SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
728id	a	b
7291	MySQL from Tutorial	DBMS stands for DataBase ...
730SELECT * FROM t1;
731id	a	b
7321	MySQL from Tutorial	DBMS stands for DataBase ...
7332	when To Use MySQL Well	After that you went through a ...
7343	where will Optimizing MySQL	what In this tutorial we will show ...
7354	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7365	adding record using session 1	for verifying multiple concurrent transactions
7376	Мога да ям стъкло	то Mне ми вреди
7387	Sævör grét	áðan því úlpan var ónýt
739SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
740SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
741id	a	b
7424	Я могу есть стекло	оно мне Mне вредит
7436	Мога да ям стъкло	то Mне ми вреди
744SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
745id	a	b
7464	Я могу есть стекло	оно мне Mне вредит
747SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
748id	a	b
7491	MySQL from Tutorial	DBMS stands for DataBase ...
750SELECT * FROM t1;
751id	a	b
7521	MySQL from Tutorial	DBMS stands for DataBase ...
7532	when To Use MySQL Well	After that you went through a ...
7543	where will Optimizing MySQL	what In this tutorial we will show ...
7554	Я могу есть стекло	оно мне Mне вредит
7565	adding record using session 1	for verifying multiple concurrent transactions
7576	Мога да ям стъкло	то Mне ми вреди
758"In connection 1"
759COMMIT;
760SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
761id	a	b
7626	Мога да ям стъкло	то Mне ми вреди
763SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
764id	a	b
765SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
766id	a	b
7677	Sævör grét	áðan því úlpan var ónýt
768"In connection 2"
769SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
770id	a	b
7716	Мога да ям стъкло	то Mне ми вреди
772SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
773id	a	b
774SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
775id	a	b
7767	Sævör grét	áðan því úlpan var ónýt
777SELECT * FROM t1;
778id	a	b
7791	MySQL from Tutorial	DBMS stands for DataBase ...
7802	when To Use MySQL Well	After that you went through a ...
7813	where will Optimizing MySQL	what In this tutorial we will show ...
7824	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7835	adding record using session 1	for verifying multiple concurrent transactions
7846	Мога да ям стъкло	то Mне ми вреди
7857	Sævör grét	áðan því úlpan var ónýt
786DROP TABLE t1;
787SET NAMES UTF8;
788CREATE TABLE t1 (
789id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
790a VARCHAR(200),
791b TEXT
792) CHARACTER SET = UTF8,ENGINE = InnoDB;
793"In connection 1"
794SET NAMES UTF8;
795INSERT INTO t1 (a,b) VALUES
796('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
797('when To Use MySQL Well','After that you went through a ...'),
798('where will Optimizing MySQL','what In this tutorial we will show ...'),
799('Я могу есть стекло', 'оно мне Mне вредит'),
800('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
801('Sævör grét', 'áðan því úlpan var ónýt');
802"In connection 2"
803SET NAMES UTF8;
804select @@session.tx_isolation;
805@@session.tx_isolation
806REPEATABLE-READ
807Warnings:
808Warning	1287	'@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
809CREATE FULLTEXT INDEX idx on t1 (a,b);
810Warnings:
811Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
812INSERT INTO t1 (a,b) VALUES
813('adding record using session 1','for verifying multiple concurrent transactions'),
814('Мога да ям стъкло', 'то Mне ми вреди');
815"In connection 1"
816SELECT * FROM t1;
817id	a	b
8181	MySQL from Tutorial	DBMS stands for DataBase ...
8192	when To Use MySQL Well	After that you went through a ...
8203	where will Optimizing MySQL	what In this tutorial we will show ...
8214	Я могу есть стекло	оно мне Mне вредит
8225	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
8236	Sævör grét	áðan því úlpan var ónýt
8247	adding record using session 1	for verifying multiple concurrent transactions
8258	Мога да ям стъкло	то Mне ми вреди
826START TRANSACTION;
827SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
828id	a	b
8298	Мога да ям стъкло	то Mне ми вреди
830DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
831DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
832SELECT * FROM t1;
833id	a	b
8341	MySQL from Tutorial	DBMS stands for DataBase ...
8352	when To Use MySQL Well	After that you went through a ...
8363	where will Optimizing MySQL	what In this tutorial we will show ...
8374	Я могу есть стекло	оно мне Mне вредит
8385	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
8397	adding record using session 1	for verifying multiple concurrent transactions
840SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
841id	a	b
8424	Я могу есть стекло	оно мне Mне вредит
843SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
844id	a	b
845SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
846id	a	b
847SELECT * FROM t1;
848id	a	b
8491	MySQL from Tutorial	DBMS stands for DataBase ...
8502	when To Use MySQL Well	After that you went through a ...
8513	where will Optimizing MySQL	what In this tutorial we will show ...
8524	Я могу есть стекло	оно мне Mне вредит
8535	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
8547	adding record using session 1	for verifying multiple concurrent transactions
855"In connection 2"
856SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
857id	a	b
8584	Я могу есть стекло	оно мне Mне вредит
8598	Мога да ям стъкло	то Mне ми вреди
860SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
861id	a	b
8628	Мога да ям стъкло	то Mне ми вреди
863SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
864id	a	b
8656	Sævör grét	áðan því úlpan var ónýt
866SELECT * FROM t1;
867id	a	b
8681	MySQL from Tutorial	DBMS stands for DataBase ...
8692	when To Use MySQL Well	After that you went through a ...
8703	where will Optimizing MySQL	what In this tutorial we will show ...
8714	Я могу есть стекло	оно мне Mне вредит
8725	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
8736	Sævör grét	áðan því úlpan var ónýt
8747	adding record using session 1	for verifying multiple concurrent transactions
8758	Мога да ям стъкло	то Mне ми вреди
876"In connection 1"
877ROLLBACK;
878SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
879id	a	b
8804	Я могу есть стекло	оно мне Mне вредит
8818	Мога да ям стъкло	то Mне ми вреди
882SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
883id	a	b
8848	Мога да ям стъкло	то Mне ми вреди
885SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
886id	a	b
8876	Sævör grét	áðan því úlpan var ónýt
888"In connection 2"
889SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
890id	a	b
8914	Я могу есть стекло	оно мне Mне вредит
8928	Мога да ям стъкло	то Mне ми вреди
893SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
894id	a	b
8958	Мога да ям стъкло	то Mне ми вреди
896SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
897id	a	b
8986	Sævör grét	áðan því úlpan var ónýt
899SELECT * FROM t1;
900id	a	b
9011	MySQL from Tutorial	DBMS stands for DataBase ...
9022	when To Use MySQL Well	After that you went through a ...
9033	where will Optimizing MySQL	what In this tutorial we will show ...
9044	Я могу есть стекло	оно мне Mне вредит
9055	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
9066	Sævör grét	áðan því úlpan var ónýt
9077	adding record using session 1	for verifying multiple concurrent transactions
9088	Мога да ям стъкло	то Mне ми вреди
909DROP TABLE t1;
910SET NAMES UTF8;
911CREATE TABLE t1 (
912id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
913a VARCHAR(200),
914b TEXT
915) CHARACTER SET = UTF8,ENGINE = InnoDB;
916"In connection 1"
917SET NAMES UTF8;
918INSERT INTO t1 (a,b) VALUES
919('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
920('when To Use MySQL Well','After that you went through a ...'),
921('where will Optimizing MySQL','what In this tutorial we will show ...'),
922('Я могу есть стекло', 'оно мне Mне вредит');
923"In connection 2"
924SET NAMES UTF8;
925select @@session.tx_isolation;
926@@session.tx_isolation
927REPEATABLE-READ
928Warnings:
929Warning	1287	'@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
930CREATE FULLTEXT INDEX idx on t1 (a,b);
931Warnings:
932Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
933INSERT INTO t1 (a,b) VALUES
934('adding record using session 1','for verifying multiple concurrent transactions'),
935('Мога да ям стъкло', 'то Mне ми вреди');
936"In connection 1"
937SELECT * FROM t1;
938id	a	b
9391	MySQL from Tutorial	DBMS stands for DataBase ...
9402	when To Use MySQL Well	After that you went through a ...
9413	where will Optimizing MySQL	what In this tutorial we will show ...
9424	Я могу есть стекло	оно мне Mне вредит
9435	adding record using session 1	for verifying multiple concurrent transactions
9446	Мога да ям стъкло	то Mне ми вреди
945START TRANSACTION;
946SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
947id	a	b
9484	Я могу есть стекло	оно мне Mне вредит
949UPDATE t1 SET a =  'Μπορῶ νὰ φάω σπασμένα' , b = 'γυαλιὰ χωρὶς νὰ πάθω τίποτα' WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
950INSERT INTO t1(a,b) VALUES ('Sævör grét', 'áðan því úlpan var ónýt');
951SELECT * FROM t1;
952id	a	b
9531	MySQL from Tutorial	DBMS stands for DataBase ...
9542	when To Use MySQL Well	After that you went through a ...
9553	where will Optimizing MySQL	what In this tutorial we will show ...
9564	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
9575	adding record using session 1	for verifying multiple concurrent transactions
9586	Мога да ям стъкло	то Mне ми вреди
9597	Sævör grét	áðan því úlpan var ónýt
960SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
961id	a	b
9626	Мога да ям стъкло	то Mне ми вреди
963SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
964id	a	b
9656	Мога да ям стъкло	то Mне ми вреди
966SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
967id	a	b
9681	MySQL from Tutorial	DBMS stands for DataBase ...
969SELECT * FROM t1;
970id	a	b
9711	MySQL from Tutorial	DBMS stands for DataBase ...
9722	when To Use MySQL Well	After that you went through a ...
9733	where will Optimizing MySQL	what In this tutorial we will show ...
9744	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
9755	adding record using session 1	for verifying multiple concurrent transactions
9766	Мога да ям стъкло	то Mне ми вреди
9777	Sævör grét	áðan því úlpan var ónýt
978"In connection 2"
979SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
980id	a	b
9814	Я могу есть стекло	оно мне Mне вредит
9826	Мога да ям стъкло	то Mне ми вреди
983SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
984id	a	b
9856	Мога да ям стъкло	то Mне ми вреди
986SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
987id	a	b
9881	MySQL from Tutorial	DBMS stands for DataBase ...
989SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
990SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
991id	a	b
9926	Мога да ям стъкло	то Mне ми вреди
993SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
994id	a	b
9956	Мога да ям стъкло	то Mне ми вреди
996SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
997id	a	b
9981	MySQL from Tutorial	DBMS stands for DataBase ...
999SELECT * FROM t1;
1000id	a	b
10011	MySQL from Tutorial	DBMS stands for DataBase ...
10022	when To Use MySQL Well	After that you went through a ...
10033	where will Optimizing MySQL	what In this tutorial we will show ...
10044	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
10055	adding record using session 1	for verifying multiple concurrent transactions
10066	Мога да ям стъкло	то Mне ми вреди
10077	Sævör grét	áðan því úlpan var ónýt
1008SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
1009SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
1010id	a	b
10114	Я могу есть стекло	оно мне Mне вредит
10126	Мога да ям стъкло	то Mне ми вреди
1013SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
1014id	a	b
10156	Мога да ям стъкло	то Mне ми вреди
1016SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
1017id	a	b
10181	MySQL from Tutorial	DBMS stands for DataBase ...
1019SELECT * FROM t1;
1020id	a	b
10211	MySQL from Tutorial	DBMS stands for DataBase ...
10222	when To Use MySQL Well	After that you went through a ...
10233	where will Optimizing MySQL	what In this tutorial we will show ...
10244	Я могу есть стекло	оно мне Mне вредит
10255	adding record using session 1	for verifying multiple concurrent transactions
10266	Мога да ям стъкло	то Mне ми вреди
1027"In connection 1"
1028ROLLBACK;
1029SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
1030id	a	b
10314	Я могу есть стекло	оно мне Mне вредит
10326	Мога да ям стъкло	то Mне ми вреди
1033SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
1034id	a	b
10356	Мога да ям стъкло	то Mне ми вреди
1036SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
1037id	a	b
1038"In connection 2"
1039SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
1040id	a	b
10414	Я могу есть стекло	оно мне Mне вредит
10426	Мога да ям стъкло	то Mне ми вреди
1043SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
1044id	a	b
10456	Мога да ям стъкло	то Mне ми вреди
1046SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
1047id	a	b
1048SELECT * FROM t1;
1049id	a	b
10501	MySQL from Tutorial	DBMS stands for DataBase ...
10512	when To Use MySQL Well	After that you went through a ...
10523	where will Optimizing MySQL	what In this tutorial we will show ...
10534	Я могу есть стекло	оно мне Mне вредит
10545	adding record using session 1	for verifying multiple concurrent transactions
10556	Мога да ям стъкло	то Mне ми вреди
1056DROP TABLE t1;
1057