When using with SAVEPOINT and ROLLBACK , what will be the output of this?

by

SAVEPOINT name– Marks a savepoint within the current transaction, there can be multiple savepoints in a transaction.

ROLLBACK TO SAVEPOINT name -ROLLBACK TO SAVEPOINT rolls back the current transaction to the specified savepoint, so it discards any changes and or savepoints created after the savepoint to which you are rolling back.

So in your problem, it will rollback to the point created after the insertion of 4,tera. So the value 5, omega will be discarded. So the select query will give

customername
-------------
    alpha
    beta
    gamma
    tera

More Related Contents:

  1. need to return two sets of data with two different where clauses
  2. SQL statement is ignoring where parameter
  3. quick selection of a random row from a large table in mysql
  4. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  5. Column calculated from another column?
  6. Error in MySQL when setting default value for DATE or DATETIME
  7. How does MySQL process ORDER BY and LIMIT in a query?
  8. Generating a random & unique 8 character string using MySQL
  9. sql joins as venn diagram
  10. MySQL, better to insert NULL or empty string?
  11. SQL: Repeat a result row multiple times, and number the rows
  12. sql join two table
  13. Compare dates in MySQL
  14. Cast int to varchar
  15. Invalid default value for ‘dateAdded’
  16. Import SQL file into mysql
  17. MySQL SELECT last few days?
  18. “where 1=1” statement [duplicate]
  19. Split a string and loop through values in MySQL stored procedure
  20. How to create dummy variable columns for thousands of categories in Google BigQuery?
  21. how to cast the hexadecimal to varchar(datetime)?
  22. MySQL Select Query – Get only first 10 characters of a value
  23. Most efficient way to store IP Address in MySQL [duplicate]
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. Postgres LEFT JOIN with WHERE condition
  26. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  27. mysql select id and name from other table and join query
  28. Optimistic locking in MySQL
  29. Insert and set value with max()+1 problems
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment