« Oracle: source text for the view, package etc | Home | Oracle: using recycling bin »
mysql: rownum functionality
Select, update etc...
UPDATE mytable
SET col1 = 'somevalue'
ORDER BY col2
LIMIT 300
SET col1 = 'somevalue'
ORDER BY col2
LIMIT 300
rownum analog:
SELECT @rownum:=@rownum+1 rownum, mytable.*
FROM (SELECT @rownum:=0) r, mytable;
FROM (SELECT @rownum:=0) r, mytable;
Topics: MySQL, rowcount | Submitter: checkthis
Comments
You must be logged in to post a comment.