depojones Posted October 16, 2010 Share Posted October 16, 2010 Thanks for reading my post. How can I update the ten rows from MYSQL Thanks in advance Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted October 16, 2010 Share Posted October 16, 2010 either loop over the 10 rows, updating them each individually, or update them all at once. it depends on whether you are setting the same field to the same value or what. can you give us more detail and some code? Quote Link to comment Share on other sites More sharing options...
depojones Posted October 16, 2010 Author Share Posted October 16, 2010 Thank you for your post. My question wasn't clear, though I wanted to ask for the first ten records. I managed to fix it though. UPDATE $tbl_name SET field_name='value' LIMIT 10 Thanks though Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.