select fields and create temp field.

popskie · #1 (**permalink**) 10-25-05, 04:42

hi,
Sory, I dont knew how to start but anyway. my problem is somthing like dis.
I have a table and a field and im using mysql 5.0.3.

Code:

table1
field1 field2
aaaa test1
bbbb test3
cccc test4
mmmm test7
lllll test8

I want a result like dis.

Code:

field1 field2 ,tempfield
aaaa test1 1
bbbb test3 2
cccc test4 3
mmmm test7 4
lllll test8 5

thanks ,
Popskie

felixg · #2 (**permalink**) 10-25-05, 06:12

Please be more precise:

1) what is the sort type and order on which column
2) what should happen with ties (i.e. when two or more values are the same w.r.t. the sort type and order)

--
felix

popskie · #3 (**permalink**) 10-25-05, 20:25

Just in any order in my sample table has just only 2 fields. Pls look at my query.

select *,_temp_incrementfield from tablename

but i dont knw how to increment in select statement. Sory for my english.

felixg · #4 (**permalink**) 10-26-05, 02:46

Quote:

Originally Posted by popskie

Just in any order in my sample table has just only 2 fields. Pls look at my query.
select *,_temp_incrementfield from tablename

I meant you need an ORDER BY. E.g.

Code:

SET @rank := 0;
SELECT 
    field1, field2, @rank := @rank+1 
FROM tablename
ORDER BY field2;

--
felix

popskie · #5 (**permalink**) 10-26-05, 04:09

thats it , nice shoot . Thanks for the rep.

Internet Services

Web Development

Digital Marketing

Consumer Tech