How To Send A MySQL Query And Update Last 10 Rows Only
- Forums
- MySQL
- How To Send A MySQL Query And Update Last 10 Rows Only
this page will show you exactly how to do a mysql query to update last 10 rows - updating the last rows is simple with this query you can use in your php script codes [930], Last Updated: Sat May 18, 2024
wallpaperama
Sat May 14, 2011
0 Comments
3929 Visits
you can use this query to update only the last 10 rows, if you want to do more or less, just change the number 10 to whatever you want. its very simple really.
if you are a beginer and not familiar with MYSQL you will find this helpful
i write these tutorials because i find them helpful when i forget how to do something
i hope you find it helpful too
so here is the query you can use:
UPDATE wallpaperama_table SET FavoriteWallpapers = 1 ORDER BY wallpaper_id LIMIT 10
the above query will set a 1 to only the last 10 FavoriteWallpapers in the wallpaperama wallpaperama_table
there are others if you need to more