& Quot; CREATEDEFINER 'root' @ '%' PROCEDURE 'newproc' () begindroptableifexiststem_request; response, SaleCycleID, response, 10; updates_betrequestset... selectmysqljava data storage process
Create definer = 'root' @ '%' PROCEDURE 'newproc' () begindrop table if exists tem_request; create temporary table tem_request select RequestID, SaleCycleID, stationID from s_betrequest where requestStatus = 0 limit 0, 10; update s_betrequest set RequestStatus = 1 where RequestID in (select RequestID from tem_request); end;
I want to start two applications and operate on the database at the same time. when this stored procedure is called, the data obtained on both sides must be inconsistent, that is, they must obtain different result sets.
The above stored procedure is to query the data and store it in the temporary table tem_request, and change the status of each piece of data to 1 (the query time is 0)
Is the mysql stored procedure synchronized or not?