GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Create auto numered column in mysql query

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Create auto numered column in mysql query

    Create auto numered column in mysql query

    select @rownum:=@rownum+1 nowef,
    p.* from item p, (SELECT @rownum:=0) r
    order by item_code
    desc limit 10;

  • #2
    I don't see a question in this post.

    Comment

    Working...
    X