drop table if exists t1;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) ENGINE = InnoDB STATS_PERSISTENT=0;
CREATE FULLTEXT INDEX idx on t1 (a,b);
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...');
START TRANSACTION;
INSERT INTO t1 (a,b) VALUES
('MySQL Tutorial','request docteam for oraclehelp.');
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request' IN NATURAL LANGUAGE MODE);
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request MySQL' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('-request +MySQL' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
id	a	b
2	when To Use MySQL Well	After that you went through a ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('"stands Database"@11' IN BOOLEAN MODE) ORDER BY 1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' WITH QUERY EXPANSION);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
2	when To Use MySQL Well	After that you went through a ...
COMMIT;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	MySQL Tutorial	request docteam for oraclehelp.
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request MySQL' IN BOOLEAN MODE);
id	a	b
4	MySQL Tutorial	request docteam for oraclehelp.
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' WITH QUERY EXPANSION);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
4	MySQL Tutorial	request docteam for oraclehelp.
3	where will Optimizing MySQL	what In this tutorial we will show ...
2	when To Use MySQL Well	After that you went through a ...
START TRANSACTION;
INSERT INTO t1 (a,b) VALUES (NULL,NULL);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+request +MySQL' IN BOOLEAN MODE);
id	a	b
4	MySQL Tutorial	request docteam for oraclehelp.
UPDATE 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);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('query performace' IN BOOLEAN MODE);
id	a	b
UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq  xyz.com ...'
WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('performace');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
id	a	b
COMMIT;
DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
SELECT * FROM t1;
id	a	b
4	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
5	NULL	NULL
INSERT INTO t1 (a,b) VALUES
('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...')  ,
('when To Use MySQL Well','for free faq  mail@xyz.com ...');
SELECT * FROM t1;
id	a	b
4	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
5	NULL	NULL
6	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
7	when To Use MySQL Well	for free faq  mail@xyz.com ...
DROP TABLE t1;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) ENGINE = InnoDB;
CREATE FULLTEXT INDEX idx on t1 (a,b);
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...');
START TRANSACTION;
INSERT INTO t1 (a,b) VALUES
('MySQL Tutorial','request docteam for oraclehelp.');
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request' IN NATURAL LANGUAGE MODE);
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request MySQL' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('-request +MySQL' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
id	a	b
2	when To Use MySQL Well	After that you went through a ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' WITH QUERY EXPANSION);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
2	when To Use MySQL Well	After that you went through a ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' WITH QUERY EXPANSION);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
2	when To Use MySQL Well	After that you went through a ...
ROLLBACK;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request MySQL' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' WITH QUERY EXPANSION);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
2	when To Use MySQL Well	After that you went through a ...
START TRANSACTION;
INSERT INTO t1 (a,b) VALUES (NULL,NULL);
UPDATE 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);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('query performace' IN BOOLEAN MODE);
id	a	b
UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq  xyz.com ...'
WHERE MATCH (a,b) AGAINST ('+query +performace' IN BOOLEAN MODE);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('performace');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
id	a	b
ROLLBACK;
DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
SELECT * FROM t1;
id	a	b
INSERT INTO t1 (a,b) VALUES
('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...')  ,
('when To Use MySQL Well','for free faq  mail@xyz.com ...');
SELECT * FROM t1;
id	a	b
6	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
7	when To Use MySQL Well	for free faq  mail@xyz.com ...
DROP TABLE t1;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) ENGINE = InnoDB;
CREATE FULLTEXT INDEX idx on t1 (a,b);
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...');
INSERT INTO t1 (a,b) VALUES
('MySQL Tutorial','request docteam for oraclehelp.');
START TRANSACTION;
INSERT INTO t1 (a,b) VALUES (NULL,NULL);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+request +MySQL' IN BOOLEAN MODE);
id	a	b
4	MySQL Tutorial	request docteam for oraclehelp.
UPDATE 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);
SELECT * from t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
5	NULL	NULL
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('query performace' IN BOOLEAN MODE);
id	a	b
UPDATE 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);
UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq mail xyz.com ...' WHERE b like '%query performace%';
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('performace');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
id	a	b
SELECT * from t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	when To Use MySQL Well	for free faq mail xyz.com ...
5	NULL	NULL
COMMIT;
SELECT * from t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	when To Use MySQL Well	for free faq mail xyz.com ...
5	NULL	NULL
DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+MySQL' IN BOOLEAN MODE);
SELECT * FROM t1;
id	a	b
5	NULL	NULL
INSERT INTO t1 (a,b) VALUES
('Trial version','query performace 1255 minute on 2.1Hz Memory 2GB...')  ,
('when To Use MySQL Well','for free faq  mail@xyz.com ...');
SELECT * FROM t1;
id	a	b
5	NULL	NULL
6	Trial version	query performace 1255 minute on 2.1Hz Memory 2GB...
7	when To Use MySQL Well	for free faq  mail@xyz.com ...
DROP TABLE t1;
SET NAMES UTF8;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) CHARACTER SET = UTF8,ENGINE = InnoDB;
connect  con1,localhost,root,,;
SET NAMES UTF8;
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...'),
('Я могу есть стекло', 'оно мне Mне вредит'),
('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
('Sævör grét', 'áðan því úlpan var ónýt');
connect  con2,localhost,root,,;
SET NAMES UTF8;
CREATE FULLTEXT INDEX idx on t1 (a,b);
connection con1;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' IN NATURAL LANGUAGE MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
INSERT INTO t1 (a,b) VALUES
('adding record using session 1','for verifying multiple concurrent transactions'),
('Мога да ям стъкло', 'то Mне ми вреди');
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+γυαλιὰ +χωρὶ*' IN BOOLEAN MODE);
id	a	b
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
START TRANSACTION;
INSERT INTO t1 (a,b) VALUES
('MySQL Tutorial','request docteam for oraclehelp.'),
('Příliš žluťoučký kůň', 'úpěl ďábelské kódy');
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request ďábelské' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' WITH QUERY EXPANSION) ORDER BY 1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
6	Sævör grét	áðan því úlpan var ónýt
connection con2;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+record +multiple' IN BOOLEAN MODE);
id	a	b
7	adding record using session 1	for verifying multiple concurrent transactions
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutor* Sævö*' IN BOOLEAN MODE) ORDER BY 1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
6	Sævör grét	áðan því úlpan var ónýt
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('usin* multipl*' IN BOOLEAN MODE);
id	a	b
7	adding record using session 1	for verifying multiple concurrent transactions
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('"request docteam"@08' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request' IN NATURAL LANGUAGE MODE);
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request MySQL' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('-request +MySQL' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+MySQL -(Tutorial Optimizing)' IN BOOLEAN MODE);
id	a	b
2	when To Use MySQL Well	After that you went through a ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('"stands Database"@11' IN BOOLEAN MODE) ORDER BY 1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('tutorial' WITH QUERY EXPANSION) ORDER BY 1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
connection con1;
COMMIT;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+request +MySQL' IN BOOLEAN MODE);
id	a	b
9	MySQL Tutorial	request docteam for oraclehelp.
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('Příliš žluťoučký' IN BOOLEAN MODE);
id	a	b
10	Příliš žluťoučký kůň	úpěl ďábelské kódy
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('Příliš');
id	a	b
10	Příliš žluťoučký kůň	úpěl ďábelské kódy
INSERT INTO t1 (a,b) VALUES (NULL,NULL);
SELECT * FROM t1 WHERE a IS NULL AND b IS NULL;
id	a	b
11	NULL	NULL
connection con2;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('usin* multipl*' IN BOOLEAN MODE);
id	a	b
7	adding record using session 1	for verifying multiple concurrent transactions
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+request +MySQL' IN BOOLEAN MODE);
id	a	b
9	MySQL Tutorial	request docteam for oraclehelp.
SELECT * FROM t1 WHERE a IS NULL AND b IS NULL;
id	a	b
11	NULL	NULL
ALTER TABLE t1 DROP INDEX idx;
CREATE FULLTEXT INDEX idx on t1 (a,b);
START TRANSACTION;
UPDATE t1 SET a = 'Trial version Příliš žluťoučký' , b = 'query performace 1255 minute on 2.1Hz Memory 2GB...'
WHERE MATCH (a,b) AGAINST ('+request +MySQL' IN BOOLEAN MODE);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+query +performace' IN BOOLEAN MODE);
id	a	b
UPDATE t1 SET a = UPPER(a) WHERE MATCH (a,b) AGAINST ('+Příliš +žluťoučký' IN BOOLEAN MODE);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+Příliš +žluťoučký' IN BOOLEAN MODE);
id	a	b
UPDATE t1 SET a = UPPER(a) WHERE a LIKE '%version Příliš%';
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+query +performace' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1 WHERE b LIKE '%query performace%';
id	a	b
9	TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ	query performace 1255 minute on 2.1Hz Memory 2GB...
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('request');
id	a	b
connection con1;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('query performace' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('performace');
id	a	b
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+mail +MySQL' IN BOOLEAN MODE);
id	a	b
connection con2;
COMMIT;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+query +performace' IN BOOLEAN MODE);
id	a	b
9	TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ	query performace 1255 minute on 2.1Hz Memory 2GB...
connection con1;
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('+query +performace' IN BOOLEAN MODE);
id	a	b
9	TRIAL VERSION PŘÍLIŠ ŽLUŤOUČKÝ	query performace 1255 minute on 2.1Hz Memory 2GB...
UPDATE t1 SET a = 'when To Use MySQL Well' , b = 'for free faq  xyz.com ...'
WHERE MATCH (a,b) AGAINST ('+πάθω +τίποτα' IN BOOLEAN MODE);
SELECT * FROM t1
WHERE MATCH (a,b)
AGAINST ('well free') ORDER BY 1;
id	a	b
2	when To Use MySQL Well	After that you went through a ...
5	when To Use MySQL Well	for free faq  xyz.com ...
disconnect con1;
disconnect con2;
connection default;
DROP TABLE t1;
SET NAMES UTF8;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) CHARACTER SET = UTF8,ENGINE = InnoDB;
connect  con1,localhost,root,,;
SET NAMES UTF8;
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...'),
('Я могу есть стекло', 'оно мне Mне вредит'),
('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
('Sævör grét', 'áðan því úlpan var ónýt');
connect  con2,localhost,root,,;
SET NAMES UTF8;
select @@session.transaction_isolation;
@@session.transaction_isolation
REPEATABLE-READ
CREATE FULLTEXT INDEX idx on t1 (a,b);
INSERT INTO t1 (a,b) VALUES
('adding record using session 1','for verifying multiple concurrent transactions'),
('Мога да ям стъкло', 'то Mне ми вреди');
connection con1;
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6	Sævör grét	áðan því úlpan var ónýt
7	adding record using session 1	for verifying multiple concurrent transactions
8	Мога да ям стъкло	то Mне ми вреди
START TRANSACTION;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
id	a	b
8	Мога да ям стъкло	то Mне ми вреди
DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7	adding record using session 1	for verifying multiple concurrent transactions
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7	adding record using session 1	for verifying multiple concurrent transactions
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
8	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
6	Sævör grét	áðan því úlpan var ónýt
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6	Sævör grét	áðan því úlpan var ónýt
7	adding record using session 1	for verifying multiple concurrent transactions
8	Мога да ям стъкло	то Mне ми вреди
connection con1;
COMMIT;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7	adding record using session 1	for verifying multiple concurrent transactions
disconnect con1;
disconnect con2;
connection default;
DROP TABLE t1;
SET NAMES UTF8;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) CHARACTER SET = UTF8,ENGINE = InnoDB;
connect  con1,localhost,root,,;
SET NAMES UTF8;
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...'),
('Я могу есть стекло', 'оно мне Mне вредит');
connect  con2,localhost,root,,;
SET NAMES UTF8;
select @@session.transaction_isolation;
@@session.transaction_isolation
REPEATABLE-READ
CREATE FULLTEXT INDEX idx on t1 (a,b);
INSERT INTO t1 (a,b) VALUES
('adding record using session 1','for verifying multiple concurrent transactions'),
('Мога да ям стъкло', 'то Mне ми вреди');
connection con1;
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
START TRANSACTION;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
UPDATE t1 SET a =  'Μπορῶ νὰ φάω σπασμένα' , b = 'γυαλιὰ χωρὶς νὰ πάθω τίποτα' WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
INSERT INTO t1(a,b) VALUES ('Sævör grét', 'áðan því úlpan var ónýt');
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
7	Sævör grét	áðan því úlpan var ónýt
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
7	Sævör grét	áðan því úlpan var ónýt
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
7	Sævör grét	áðan því úlpan var ónýt
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
connection con1;
COMMIT;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
7	Sævör grét	áðan því úlpan var ónýt
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стекло');
id	a	b
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
7	Sævör grét	áðan því úlpan var ónýt
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
7	Sævör grét	áðan því úlpan var ónýt
disconnect con1;
disconnect con2;
connection default;
DROP TABLE t1;
SET NAMES UTF8;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) CHARACTER SET = UTF8,ENGINE = InnoDB;
connect  con1,localhost,root,,;
SET NAMES UTF8;
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...'),
('Я могу есть стекло', 'оно мне Mне вредит'),
('Μπορῶ νὰ φάω σπασμένα' ,'γυαλιὰ χωρὶς νὰ πάθω τίποτα'),
('Sævör grét', 'áðan því úlpan var ónýt');
connect  con2,localhost,root,,;
SET NAMES UTF8;
select @@session.transaction_isolation;
@@session.transaction_isolation
REPEATABLE-READ
CREATE FULLTEXT INDEX idx on t1 (a,b);
INSERT INTO t1 (a,b) VALUES
('adding record using session 1','for verifying multiple concurrent transactions'),
('Мога да ям стъкло', 'то Mне ми вреди');
connection con1;
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6	Sævör grét	áðan því úlpan var ónýt
7	adding record using session 1	for verifying multiple concurrent transactions
8	Мога да ям стъкло	то Mне ми вреди
START TRANSACTION;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
id	a	b
8	Мога да ям стъкло	то Mне ми вреди
DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('+Мога +Mне' IN BOOLEAN MODE);
DELETE FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7	adding record using session 1	for verifying multiple concurrent transactions
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
7	adding record using session 1	for verifying multiple concurrent transactions
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
8	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
8	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
6	Sævör grét	áðan því úlpan var ónýt
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6	Sævör grét	áðan því úlpan var ónýt
7	adding record using session 1	for verifying multiple concurrent transactions
8	Мога да ям стъкло	то Mне ми вреди
connection con1;
ROLLBACK;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
8	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
8	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
6	Sævör grét	áðan því úlpan var ónýt
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
8	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
8	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
6	Sævör grét	áðan því úlpan var ónýt
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
6	Sævör grét	áðan því úlpan var ónýt
7	adding record using session 1	for verifying multiple concurrent transactions
8	Мога да ям стъкло	то Mне ми вреди
disconnect con1;
disconnect con2;
connection default;
DROP TABLE t1;
SET NAMES UTF8;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) CHARACTER SET = UTF8,ENGINE = InnoDB;
connect  con1,localhost,root,,;
SET NAMES UTF8;
INSERT INTO t1 (a,b) VALUES
('MySQL from Tutorial','DBMS stands for DataBase ...')  ,
('when To Use MySQL Well','After that you went through a ...'),
('where will Optimizing MySQL','what In this tutorial we will show ...'),
('Я могу есть стекло', 'оно мне Mне вредит');
connect  con2,localhost,root,,;
SET NAMES UTF8;
select @@session.transaction_isolation;
@@session.transaction_isolation
REPEATABLE-READ
CREATE FULLTEXT INDEX idx on t1 (a,b);
INSERT INTO t1 (a,b) VALUES
('adding record using session 1','for verifying multiple concurrent transactions'),
('Мога да ям стъкло', 'то Mне ми вреди');
connection con1;
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
START TRANSACTION;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
UPDATE t1 SET a =  'Μπορῶ νὰ φάω σπασμένα' , b = 'γυαλιὰ χωρὶς νὰ πάθω τίποτα' WHERE MATCH (a,b) AGAINST ('+могу +Mне' IN BOOLEAN MODE);
INSERT INTO t1(a,b) VALUES ('Sævör grét', 'áðan því úlpan var ónýt');
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
7	Sævör grét	áðan því úlpan var ónýt
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
7	Sævör grét	áðan því úlpan var ónýt
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Μπορῶ νὰ φάω σπασμένα	γυαλιὰ χωρὶς νὰ πάθω τίποτα
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
7	Sævör grét	áðan því úlpan var ónýt
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"dbms stands"@05' IN BOOLEAN MODE);
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
connection con1;
ROLLBACK;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
connection con2;
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('+Mне' IN BOOLEAN MODE);
id	a	b
4	Я могу есть стекло	оно мне Mне вредит
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('стъкло');
id	a	b
6	Мога да ям стъкло	то Mне ми вреди
SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('"Sævör grét"@18' IN BOOLEAN MODE);
id	a	b
SELECT * FROM t1;
id	a	b
1	MySQL from Tutorial	DBMS stands for DataBase ...
2	when To Use MySQL Well	After that you went through a ...
3	where will Optimizing MySQL	what In this tutorial we will show ...
4	Я могу есть стекло	оно мне Mне вредит
5	adding record using session 1	for verifying multiple concurrent transactions
6	Мога да ям стъкло	то Mне ми вреди
disconnect con1;
disconnect con2;
connection default;
DROP TABLE t1;