Mysql after executing a SQL query to update fields, such as the update table set a=*, query a updated values in the table again, demand results in a single SQL

CodePudding user response:

Used to have this functionality, mysql a statement should be no,

CodePudding user response:

Good thank you

CodePudding user response:

MySQL can't use the method of the output, do not know 8.0 line not line, the original poster can use stored procedures, or write a trigger to other tables to become to realize this function,

CodePudding user response:

begin;
The update table set a=*;
Select the from a table;
commit;

CodePudding user response:

Try mysql function