Avoid column duplicate printing in mysql

[uffa14]

I have a Mysql table that looks like this:
model text(10) the moodel of item
color text(10) the color of item

i have some records:
1) "pippo";"red"
2) "pippo";"yellow"
3) "pippo";"green"
4) "gino";"blue"
4) "gino";"red"
4) "gino";"black"

if i do this query
select name, color from table order by 1,2
I will have this results:

name           color
gino           black
gino           blue
gino           red
pippo          green
pippo          red
pippo          yellow
 

I would like to have

name           color
gino           black
               blue
               red
pippo          green
               red
               yellow
 

Is there a mysql whai to have this results?

Thanks!

[Rabbit]

You will need to number the rows and partition it by the name.

If you do not know how to do that, you can use one of these methods:
http://www.xaprb.com/blog/2005/09/27...mber-function/
http://www.xaprb.com/blog/2006/12/02...rows-in-mysql/

You can then use a CASE statement to show the name only if the row number is one.

[uffa14]

Thanks!!
Using the examples in your link I've got what i need!!

set @type = '';
set @num  = 1;
 
select
   @num := if(@type = type, "", type) as row_number,
   @type := type as dummy,
variety
from fruits;

That give me this results:

+------------+--------+------------+
| row_number | dummy  | variety    |
+------------+--------+------------+
| apple      | apple  | fuji       |
|            | apple  | gala       |
|            | apple  | limbertwig |
| cherry     | cherry | bing       |
|            | cherry | chelan     |
| orange     | orange | navel      |
|            | orange | valencia   |
| pear       | pear   | bartlett   |
|            | pear   | bradford   |
+------------+--------+------------+
 
 

[Rabbit]

Glad you got it working, good luck with the rest of your project.