Display 1 to 100

[Hasti]

Hello Everyone

              I want to display value from 1 to 100 using select query without using table name..

 

Thanks in Advance

[trq]

What exactly do you mean?

[Hasti]

Hello

      I want to display value from 1 to 100

     

      Result

----------------------

    fieldname

---------------------

        1

        2

        .

        .

      100

 

This way i want to display using select query...

 

[trq]

Nope, still not making much sense.

[Hasti]

Hello

          for example select 1+1

        it will output as 2

 

        Now i want in same way to display a range between 1 to 100 using select query. Is this possible

 

 

[trq]

Yeah, i'm not sure that can easily be done.

 

May I ask why that would be at all useful?

[Hasti]

Ok Lets forget it.

    What i need is this.. suppose for example, a X table contain 10 rows in table with primary key as auto increment. now suppose i deleted the 4th row than now i want to use that deleted auto increment key  for new record insertion. Through query only without using php code.

 

[trq]

Why would you want to do that? Auto incrementing keys should not be manually manipulated, they are there simply to keep data integrity.

[Hasti]

In registration form they need the registration No in sequence order thats why i need this.

[trq]

Going backward and getting old numbers is not exactly a sequence. Besides, you can't insert a record into an auto incrementing field.

[kickstart]

Hi

 

While I agree that you shouldn't insert into an auto increment field, you can get a range of numbers.

 

Have a table (say call it integer) with a single column called i, with 10 rows of 0 to 9.

 

You can get the numbers 0 to 9 by doing SELECT i FROM integer.

 

To get 0 to 99 do SELECT a.i*10+b.i FROM integer a, integer b

 

So to get 40 to 80:-

 

SELECT *

FROM (SELECT a.i*10+b.i as SomeNumber FROM integer a, integer b)

WHERE SomeNumber BETWEEN 40 and 80

 

All the best

 

Keith