asked on

Update last 10 records?

Searched the web to find out how to update the last 10 rows of my table (MySQL) but I can't seem to find anything. Is there such a way? I need to be able to update the last 10 rows dynamically so I won't know any specific ID's to specify the update.

Thanks,

Guy Hengel [angelIII / a3]

last 10 in a given ORDER BY ... ASC <=> first 10 using ORDER BY ... DESC

so, just use the proper ORDER BY and add the LIMIT 0,10, so it should be fine.

Angelp1ay

So something like:

UPDATE Set field = blah ORDER BY id_field DESC LIMIT 10

brihol44

ASKER

hmm.....I'm getting an error with my update statement.

Incorrect usage of UPDATE and ORDER BY

    UPDATE stats_daily s
    INNER JOIN stats_daily_temp st
    ON s.date = st.date
    SET s.page_views = st.page_views,
	    s.visits = st.visits,
		s.hits = st.hits,
		s.bandwidth = st.bandwidth
	WHERE s.date = st.date
	ORDER BY daily_id DESC LIMIT 10

Open in new window

ASKER CERTIFIED SOLUTION

Angelp1ay

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

ee_rlee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.