Re: making two fields primary key ????

2002-10-13 Thread Peter Goggin
primary key rule. The syntax will be ALTER TABLE tablename ADD PRIMARY KEY (colname1, colname2,...) If you havent done so I suggest you download a copy of the manual. As computer manual go it is first class and will cover all that you need. Regards Peter Goggin - Original Message - From

Re: where clause question

2002-10-06 Thread Peter Goggin
This requires a similar function to Oracles decode. I do not know if MySQL provides such a function. Regards Peter Goggin - Original Message - From: "Alex Shi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 07, 2002 6:47 AM Subject: where

Re: mysql permanent connections

2002-09-29 Thread Peter Goggin
permanent connection? (Documentation says mysql_close() does not close permanent connections) Do permanet connections die when the internet connection is broken? Thanks in advance for any help. Regards Peter Goggin - Before posting

Re: Setting up a web server wit Redhat 7.3

2002-09-26 Thread Peter Goggin
machine with apache, mysql and php. Is there any documentation which lists all of these error conditions and suggests ways of solving them? Regards Peter Goggin - Before posting, please check: http://www.mysql.com

Re: Mysql Error

2002-09-25 Thread Peter Goggin
on my win98 machine with apache, mysql and php. Is there any documentation whoich lists all of these error conditions ans suggests ways of solving them? Regards Peter Goggin - Original Message - From: "Thomas Seifert" <[EMAIL PROTECTED]> To: "Peter Goggin" <[

Re: Mysql Error

2002-09-25 Thread Peter Goggin
The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: "Iikka Meriläinen" <[EMAIL PROTECTED]> T

Mysql Error

2002-09-25 Thread Peter Goggin
mysql functions? Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]&

Re users in mysql

2002-09-22 Thread Peter Goggin
cess denied for user 'reguser@localhost' (Using password = YES) I have tried changing the password with update mysql.user set password = PASSWORD('regpassword') and this does not help Can anyone suggest what I need todo? Do I need to drop the users and run the full set of gra

Re: Installing mysql in redhat linux 7.1

2002-09-19 Thread Peter Goggin
0920 14:55:31 Can't init databases 020920 14:55:31 mysqld ended Can anyone tell me what the problem is? Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Re: Oracle to Mysql

2002-09-19 Thread Peter Goggin
more detail please e-mail me directly. Regards Peter Goggin - Original Message - From: "RP C987342" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 4:29 PM Subject: Oracle to Mysql > hello > > I want to move my database fr

Re: MySQL on Redhat 7.3

2002-09-18 Thread Peter Goggin
MySQL-server conflicts with mysql-server-3.23.49-3 MySQL-DBI-Perl-bin is needed by MySQL-bench-3.23.52-1 Do I need to deinstall all of the old rpms first or is there some form of force command I should use? Regards Peter Goggin

Re: Re MySQL on Redhat 7.3

2002-09-17 Thread Peter Goggin
installed after the others. Is this correct and if so where can I down load it. (the current version is 3.23.52) Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Setting up a web server wit Redhat 7.3

2002-09-11 Thread Peter Goggin
advice and information. Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

Mysql with innodb support

2002-09-10 Thread Peter Goggin
I am setting up a web site with Linux (redhat 7.1), apache, php and mysql. I need the version of mysql with innodb support. Can anyone indicate to me what file or files I need to obtain to install thecorrect version of mysql and where I can down load them? Thanks in advance Regards Peter

Installing mysql in redhat linux 7.1

2002-09-03 Thread Peter Goggin
showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php

Re: Problem with ALTER query

2002-09-03 Thread Peter Goggin
showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http