Re: combining fields in select

2003-09-18 Thread Michael Piko
I am trying to select the firstname and surname fields from a table. select firstname + surname fullname from people; This does work in other databases but does not seem to work here. Am I doing something wrong or is there a different way to achieve this with mysql? Michael -- MySQL Gen

combining fields in select

2003-09-18 Thread Michael Piko
I am trying to select the firstname and surname fields from a table. select firstname + surname fullname from people; This does work in other databases but does not seem to work here. Am I doing something wrong or is there a different way to achieve this with mysql? Michael

Re: Querying a Linux machine

2003-08-29 Thread Michael Piko
Its a standard RedHat 8.0 install. MySQL version is 3.23.52-3 installed from the standard RPMs - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 7:56 PM Subject: Re: Querying a Linux machine

Re: Querying a Linux machine

2003-08-29 Thread Michael Piko
ust 29, 2003 4:17 PM Subject: Re: Querying a Linux machine > On Fri, 29 Aug 2003 09:15:48 +1000 > Michael Piko <[EMAIL PROTECTED]> wrote: > > > I should have mentioned the error: > > [kryten2] ERROR 2013: Lost connection to MySQL server during query > > check y

Re: Querying a Linux machine

2003-08-28 Thread Michael Piko
I should have mentioned the error: [kryten2] ERROR 2013: Lost connection to MySQL server during query - Original Message - From: "Michael Piko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 9:01 AM Subject: Querying a Linux machine >

Querying a Linux machine

2003-08-28 Thread Michael Piko
I have mysql on a Linux machine and can connect to through 'localhost' and its real IP/hostname. I cannot connect to it from other machines. Is there anything I need to do to make this happen? Michael Piko -- MySQL General Mailing List For list archives: http://lists.mysql.co