OUTPUT Clause in MySQL

by
  1. You could create a trigger and insert values you need into another table.
  2. I’m not sure, but – for MYISAM tables you could lock employee table, select and insert values into another table, and then update and unlock employee table.

EDIT:

I have tried one scenario with InnoDb table, seems it works –

START TRANSACTION;

SELECT * FROM table WHERE id = 1 FOR UPDATE; -- lock rows
-- Or call this select to insert and lock rows
-- INSERT INTO table_output SELECT * FROM table WHERE id = 1 FOR UPDATE;

-- Make modifications
UPDATE table SET column1 = '111' WHERE id = 1;

COMMIT;

SELECT statement (FOR UPDATE clause)

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. SQL split values to multiple rows
  3. Get records with max value for each group of grouped SQL results
  4. How to populate a table with a range of dates?
  5. MYSQL OR vs IN performance
  6. SELECTING with multiple WHERE conditions on same column
  7. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  8. How to find gaps in sequential numbering in mysql?
  9. MySQL: Invalid use of group function
  10. Convert timestamp to date in MySQL query
  11. Update a column value, replacing part of a string
  12. MySQL: View with Subquery in the FROM Clause Limitation
  13. MySql export schema without data
  14. mysql dynamic query in stored procedure
  15. MySQL combine two columns into one column
  16. MySQL Insert Into from one Database in another
  17. Using ORDER BY and GROUP BY together
  18. Sorting by date & time in descending order?
  19. MySQL Pivot Table Column Data as Rows
  20. updating columns with a sequence number mysql
  21. MySQL, Concatenate two columns
  22. Select a column with a keyword name
  23. MySQL Stored Procedures not working with SELECT (basic question)
  24. ERROR 1148: The used command is not allowed with this MySQL version
  25. Use Composite Primary Key as Foreign Key
  26. How to select data where a field has a min value in MySQL?
  27. How to SELECT by MAX(date)?
  28. get a recursive parent list
  29. MySQL: Computed Column
  30. mySQL query to search all tables within a database for a string?

Leave a Comment