Professional Web Applications Themes

I want to add the row number as a column of the result set - MySQL

this is for the reporting does someone knows?...

Sponsored Links
  1. #1

    Default I want to add the row number as a column of the result set

    this is for the reporting
    does someone knows?

    Sponsored Links
    hi Guest

  2. #2

    Default Re: I want to add the row number as a column of the result set

    On 25 Apr 2007 21:39:39 -0700, hi and hello wrote: 

    Add an autoincrementing integer column. Use that. They make dandy
    primary keys as well.

    --
    53. If the beautiful princess that I capture says "I'll never marry you!
    Never, do you hear me, NEVER!!!", I will say "Oh well" and kill her.
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  3. #3

    Default Re: I want to add the row number as a column of the result set

    On Apr 26, 5:27 pm, "Peter H. Coffin" <com> wrote: 
    >
    > Add an autoincrementing integer column. Use that. They make dandy
    > primary keys as well.
    >
    > --
    > 53. If the beautiful princess that I capture says "I'll never marry you!
    > Never, do you hear me, NEVER!!!", I will say "Oh well" and kill her.
    > --Peter Anspach's list of things to do as an Evil Overlord[/ref]


    You can also do this:

    mysql> set N = 0;
    mysql> SELECT N := N +1 AS number, * FROM my_table;

    strawberry Guest

  4. #4

    Default Re: I want to add the row number as a column of the result set

    On Apr 28, 2:44 pm, strawberry <com> wrote: 
    > [/ref]


    >
    > You can also do this:
    >
    > mysql> set N = 0;
    > mysql> SELECT N := N +1 AS number, * FROM my_table;[/ref]


    Actually, if using ' * ', then it has to come before the counter.
    Also, you have to remember to reset N afterwards!

    strawberry Guest

  5. #5

    Default Re: I want to add the row number as a column of the result set

    What you're asking for is "an un-natural act" in SQL. The point is
    taht an SQL

    ashore Guest

Similar Threads

  1. 2 horizontal column, but with odd number of result = empty cell!!
    By Jay in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: August 28th, 07:47 PM
  2. how to add another column to a query result?
    By Junaili Lie in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 7th, 06:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139