SEO

#1 (**permalink**) 02-28-2008, 09:41 AM

this is for the reporting
does someone knows?

#2 (**permalink**) 02-28-2008, 09:41 AM

On 25 Apr 2007 21:39:39 -0700, hi and hello wrote:
> this is for the reporting
> does someone knows?

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

#3 (**permalink**) 02-28-2008, 09:42 AM

On Apr 26, 5:27 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On 25 Apr 2007 21:39:39 -0700, hi and hello wrote:
>
> > this is for the reporting
> > does someone knows?
>
> 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

You can also do this:

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

#4 (**permalink**) 02-28-2008, 09:42 AM

On Apr 28, 2:44 pm, strawberry <zac.ca...@gmail.com> wrote:
> On Apr 26, 5:27 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
>
> > On 25 Apr 2007 21:39:39 -0700, hi and hello wrote:
>
> > > this is for the reporting
> > > does someone knows?
>
> > 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
>
> You can also do this:
>
> mysql> set @N = 0;
> mysql> SELECT @N := @N +1 AS number, * FROM my_table;

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

#5 (**permalink**) 02-28-2008, 09:43 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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