Re: MySQL unsuccesfully installed. Need help!

2003-07-11 Thread Emile State
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 of directories).

Either gcc is not installed or the PATH variable is set incorrectly. To
check how the path variable is set, type

echo $PATH

Take care of that problem and try the install again.

Emile State


on 7/11/03 09:09 AM, gerald_clark at [EMAIL PROTECTED] wrote:

> Compiling MySQL from the source tarball is not for linux newbies.
> Get the RPMs.
> 
> root wrote:
> 
>> hi there,
>> 
>> I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
>> created directory /home/users/mysql and add group for mysql. Those are the
>> command that I've used previously:
>> 
>> configure:error: no acceptable C compiler found in $PATH
>> 
>> then when i tried to run this command
>> 
>> shell>scripts/mqsql_install_db
>> 
>> it also give me an error that is no such file or directory. I really don't
>> know what to do. Please do help me.
>> 
>> 
>> Frankly speaking, i'm still new to linux and mySQL. 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Sorry

2003-07-11 Thread Emile State
Sorry about my previous post. I meant that reply for a different message.

Emile State


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: columns to rows

2003-07-11 Thread Emile State
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 of directories).

Either gcc is not installed or the PATH variable is set incorrectly. To
check how the path variable is set, type

echo $PATH

Take care of that problem and try the install again.

Emile State

on 7/11/03 10:24 AM, harm at [EMAIL PROTECTED] wrote:

> 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
>> 2kljhd2
>> 2asdd3
>> 
>> that I wish to convert to this structure.
>> 
>> no d1d2d3
>> 1 uytklhoiu
>> 2 kjhkljh   asd
> 
> something like:
> select no.no, d1.data, d2.data, d3.data from no, data as d1, data as d2, data
> as d3 where no.no = d1.no and no.no = d2.no and no.no = d3.no order by
> no.no;
> 
> Good luck,
> 
> Harmen
> 
> 
>> 
>> Given that the original has over 100,000 records, I was hoping to find some
>> reasonable way of doing it.
>> 
>> Thanking you,
>> 
>> PhilE
>> 

-- 
Emile & Marion State
132 Thornway Ave
Thornhill, ON
L4J 7Z3

(905) 669-5652



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]