mysqld_multi - Cant find mysqld in my.cnf

Hi, I have an odd problem with mysqld_multi. I am trying to set up several MySQL servers on my new development server, for testing purposes. I currenty have only one, 4.0.9, just want to get this one going first. However, when I try to start mysqld_multi, it seems it does not recognise the

RE: combining fields in select

On 18 September, 2003 11:56, Michael Piko [SMTP:[EMAIL PROTECTED] wrote: I am trying to select the firstname and surname fields from a table. select firstname + surname fullname from people; try: select concat(firstname,surname) as fullname from people; HTH, Mark