Update multiple entries mysql

Learn more. Asked 8 years, 8 months ago. Active 8 years, 8 months ago. Viewed 5k times. I'm new to php and mySql. I'm trying to update multiple row by using php and mysql. Please help. I very much appreciate any helps. What do you mean "it doesn't work? Please, do not do escaping like this. Where did you learn to do it this way?

The query is running but the it only updated the last row in database — user Show 5 more comments. Adriaan Koster Does this answer your question? Add a comment. Active Oldest Votes. Gordon Linoff Gordon Linoff 1. I don't understand your comment. You may have a different problem. Thank you very much for your time. Show 12 more comments. However, this approach makes prepared statements easier to build and more concise.

John 11k 11 11 gold badges 82 82 silver badges bronze badges. Trevedhek Trevedhek 3, 2 2 gold badges 17 17 silver badges 14 14 bronze badges. Thank you! Note: This will add new rows if the key does not exist in the table resulting in unwanted records. To do this, we can select a random employee whose job title is Sales Rep from the employees table and update it for the employees table.

This query selects a random employee from the table employees whose job title is the Sales Rep. If you query data from the employees table, you will see that every customer has a sales representative. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

Learn more. Asked 10 years, 10 months ago. Active 4 years, 1 month ago. Viewed k times. Juan Mellado Chris Chris 3 3 gold badges 8 8 silver badges 16 16 bronze badges. Add a comment. Active Oldest Votes.