How to suppress repeating columns?

[Alex Pavluck]

survey Test Result N
adult BmR1 neg 1
adult ICT not 1
adult MF pos 1
child ICT neg 2

With the above table as an example, how can I only print Adult once
and then Child once? What is that called? The new table would look
like this:

survey Test Result N
adult BmR1 neg 1
ICT not 1
MF pos 1
child ICT neg 2

[www.1-script.com]

responding to
http://www.1-script.com/forums/How-to-suppress-repeating-columns-article8785--22.htm

Post by Alex Pavluck
survey Test Result N
adult BmR1 neg 1
adult ICT not 1
adult MF pos 1
child ICT neg 2
With the above table as an example, how can I only print Adult once
and then Child once? What is that called? The new table would look
survey Test Result N
adult BmR1 neg 1
ICT not 1
MF pos 1
child ICT neg 2

I'm not too sure about what you're trying to achieve but it sounds like
something to do in an external script. Execute a query to read all rows
with all columns in them, then format the output EXTERNALLY to your
heart's desire.

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

[onedbguru]

responding tohttp://www.1-script.com/forums/How-to-suppress-repeating-columns-arti...

survey     Test    Result  N
adult      BmR1    neg     1
adult      ICT     not     1
adult      MF      pos     1
child      ICT     neg     2
With the above table as an example, how can I only print Adult once
and then Child once?  What is that called?  The new table would look
survey Test        Result N
adult        BmR1  neg     1
          ICT              not     1
          MF               pos     1
child        ICT           neg     2

I'm not too sure about what you're trying to achieve but it sounds like
something to do in an external script. Execute a query to read all rows
with all columns in them, then format the output EXTERNALLY to your
heart's desire.
-------------------------------------
--
Cheers,
Dmitrihttp://www.1-script.com/

In Oracle, it would be the CONNECT BY statement. There are some
google results that have a poor-man's way of doing this in mysql.