Custom Search
 


Data Manipulation



Data Manipulation is used to insert, update, and delete data in databases. This section covers the most common used MySQL commands for data manipulations.


1. Update Statement in MySQL


2. How to update data in a specific order in MySQL


3. How to update top N rows of data in MySQL


4. Use outer join in update


5. How to do cross-table update in MySQL - Part 1


6. How to do cross-table update in MySQL - Part 2


7. Using Bulk Insert Statement


8. Basic insert statement


9. How to create and use AUTO_INCREMENT column and use LAST_INSERT_ID function


10. Combine update and insert into one statement


11. Using MySQL REPLACE (INTO) to mimic DELETE + INSERT


12. Update multiple rows (distinctive by primary key) with different values in one query


13. Update multiple rows (distinctive by primary key) for multiple columns in one query


Back to Tutorial Index: MySQL Database How-to Articles and Tutorials

Copyright © 2024 GeeksEngine.com. All Rights Reserved.

This website is hosted by HostGator.

No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.

 
Home | Feedback | Terms of Use | Privacy Policy