Skip to content

Update

IT Notes → Database → SQL @ December 22, 2020

START TRANSACTION;

UPDATE tablename
SET fieldname = value
WHERE fieldname = value;

ROLLBACK work;

COMMIT work;

If some error occurs, we can Rollback work but it needs Start transaction. Once we are sure we can commit

Related Posts

  1. SQL ( IT Notes → Database → SQL )
  2. Create Table ( IT Notes → Database → SQL )
  3. Import Data ( IT Notes → Database → SQL )
  4. Select ( IT Notes → Database → SQL )
  5. Delete ( IT Notes → Database → SQL )
  6. Join ( IT Notes → Database → SQL )
  7. Create ( IT Notes → Database → SQL )
  8. View ( IT Notes → Database → SQL )
  9. General ( IT Notes → Database )
  10. RDBMS ( IT Notes → Database )
  11. Data Model ( IT Notes → Database )
  12. Logical Data Model ( IT Notes → Database )
  13. Physical and Relational Data Model ( IT Notes → Database )
  14. Data Normalization ( IT Notes → Database )
  15. Managing the RDBMS ( IT Notes → Database )
  16. Security ( IT Notes → Database )
  17. Performance Issue ( IT Notes → Database )
  18. Insert ( IT Notes → SQL )
  19. Programming ( IT Notes → Database )
  20. MS SQL ( IT Notes → Database )
  21. Introduction ( IT Notes → Database → Oracle )
  22. Data Definition Language ( IT Notes → Database → Oracle )
  23. Data Manipulation Language ( IT Notes → Database → Oracle )
  24. Data Control Language ( IT Notes → Database → Oracle )
  25. Transaction Control Language ( IT Notes → Database → Oracle )
  26. Miscellaneous ( IT Notes → Database → Oracle )
  27. Abbreviations ( IT Notes → Abbreviations )
  28. OOP Concepts or Object Oriented Programming Concepts ( IT Notes → Object Oriented Programming )
  29. Basics ( IT Notes → Javascript )
  30. Regex ( IT Notes → Javascript )
  31. Functions ( IT Notes → Javascript )
  32. General ( IT Notes → Javascript )
  33. Debugging ( IT Notes → Javascript )
  34. Data Types ( IT Notes → PHP )
  35. Operators ( IT Notes → PHP )
  36. Design Pattern ( IT Notes → PHP )
  37. Security ( IT Notes → PHP )
  38. Streams and Network Programming ( IT Notes → PHP )
  39. Arrays ( IT Notes → C# )
  40. Namespace ( IT Notes → C# )
  41. Indexers ( IT Notes → C# )
  42. Generics ( IT Notes → C# )
  43. Attributes ( IT Notes → C# )
  44. Anonymous Types ( IT Notes → C# )
  45. Performance Thumb Rules ( IT Notes → C# )
  46. Different Types of Testing ( IT Notes → Testing )
  47. SAS 70 Type II Audit – Data Security ( IT Notes → Testing )
  48. Tracking Defects ( IT Notes → Testing )
  49. General ( IT Notes → SEO )
  50. IT Notes ( IT Notes )
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x