RE: How does one transpose a group of columns into rows?

From: Jacob, Raymond A Jr [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 12:05 AM To: mysql@lists.mysql.com Subject: How does one transpose a group of columns into rows? I have a table: Id  |path1  | display| value 1  | ostype |  os    |windows 1  | ostype

How does one transpose a group of columns into rows?

I have a table: Id |path1 | display| value 1 | ostype | os|windows 1 | ostype | ver |NT4 2 | ostype | os | linux 2 | ostype | ver | RHEL 5.4 That I would like to tranform into Id | os| ver 1 |windows | NT4 2| linux |RHEL 5.4 Thank you, Raymond smime.p7s

Matching Different Tables' Columns and Rows

Hi, I am having the toughest time accomplishing this. I am asking for any examples or links to info pertaining to this as I want to make an effort before posting any code. After matching the specific rows by an identifying column between two tables.. I can manipulate some data albeit on a minor

Matching Different Tables' Columns and Rows

Basically, I want to match specific rows with ONLY a specific date. Here's the code: mysql_select_db($database_connBlog, $connBlog); $query_FindArticleDates = SELECT * FROM blg_article_art, blg_topic_top WHERE blg_article_art.idtop_art = blg_topic_top.id_top; $findArticleDates =

RE: columns to rows

. No data date 1uyt d1 1abc d1 cheers /rudy -Original Message- From: Phil Evans [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juli 2003 17:12 To: [EMAIL PROTECTED] Subject: columns to rows Hi there. I am a rank amateur at this trying to make sense out of a heap

columns to rows

Hi there. I am a rank amateur at this trying to make sense out of a heap (and growing) of data. I have a resultset with this structure: nodatadate 1uytd1 1klhd2 1oiud3 2kjhd1 2kljhd2 2asdd3 that I wish to convert to this structure. no

Re: columns to rows

On Sat, Jul 12, 2003 at 01:11:41AM +1000, Phil Evans wrote: Hi there. I am a rank amateur at this trying to make sense out of a heap (and growing) of data. I have a resultset with this structure: nodatadate 1uytd1 1klhd2 1oiud3 2kjhd1 2kljh

Re: columns to rows

Phil Evans [EMAIL PROTECTED] wrote: Hi there. I am a rank amateur at this trying to make sense out of a heap (and growing) of data. I have a resultset with this structure: nodatadate 1uytd1 1klhd2 1oiud3 2kjhd1 2kljhd2 2asdd3

Re: columns to rows

I disagree, even though I had my own share of problems in compiling 4.0.13. The clue is in the error message configure:error: no acceptable C compiler found in $PATH It is very likely that if he typed which cc or which gcc the reply would come back No cc (gcc) in ... (a list