J
J
JackShcherbakov2018-03-16 17:14:33
MySQL
JackShcherbakov, 2018-03-16 17:14:33

Why is an unfixed transaction by the 1st user displayed by the 2nd?

Hello colleagues! I recently encountered the following problem:
the 1st user executes the following commands:

SET AUTOCOMMIT = 0;
START TRANSACTION;
 INSERT INTO Order VALUES (NULL, 3, 22.29, '2013-02-21');

Note that the transaction was not committed, so why can user3 see the inserted row in his session?
Many thanks in advance to everyone who helps

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg, 2018-03-16
@JackShcherbakov

engine type at tables what? https
://dev.mysql.com/doc/refman/5.7/en/myisam-sto...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question