Home > database >  Prompt deleted successful, also can not query, but after login again, delete the data is still there
Prompt deleted successful, also can not query, but after login again, delete the data is still there

Time:09-20

Mysql + QT
Very simple an SQL statement
Sprintf (buff, "delete from fuel_log where id=% d", slt_id);
Prompt deleted successful operation, also can not query delete records, after I shut down the software, in the open again, again query, delete data remains strong,
Delete, again a second time before geodesic remove out of the database,
Sometimes one can delete, really confused,,,
The younger brother new to this, I don't know whether to submit enforcement order? How to solve this problem,? Thank you for your attention

CodePudding user response:

Online, such as junction post immediately,

CodePudding user response:

This operation: add a new record, and then deleted, can appear the above situation,
But if: after add records, close the connection and the software, the restart software, and deleting records, so that we can, why?

CodePudding user response:

Knot stick, oneself solved, put operation in the stored procedure is OK

CodePudding user response:

Submit is set to true can also automatically

CodePudding user response:

Did not commit, the transaction did not submit, possible
  • Related