How to solve the problem with mysql (there is no data in the database after adding, with the current connection)?

Question

MySQL

Hello
, the problem is as follows:
we execute a query in mysql to add a record.
and if immediately after that you execute a query to select this record or delete it, then mysql responds that there is no added record, and only if you reconnect to the database, then the data becomes available from mysql.
is it possible to access the data immediately, thanks in advance.

Answer 1

The description looks like a disabled autocommit.
True, in this case, the database should be updated by commit, and not by disconnection.
Perhaps the problem is in the method of accessing mysql.
Where are you accessing the database from and how?
Try, for verification purposes, after the request to add data, perform a commit.

Answer 2

PHP accessing through mysql_query() functions and InnoDB tables?