RE: combining fields in select

[Mark Hewitt]

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
---
Windows, Linux and Internet Development Consultant
Email: [EMAIL PROTECTED]
Web: http://www.scriptsmiths.co.za
---


 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
DISCLAIMER: This e-mail and its attachments may contain information that is
confidential and that may be subject to legal privilege and copyright. If
you are not the intended recipient you may not peruse, use, disclose,
distribute, copy or retain this message. If you have received this message
in error, please notify the sender immediately by e-mail, facsimile or
telephone and return and thereafter destroy the original message.Please note
that e-mails are subject to viruses, data corruption, delay, interception
and unauthorised amendment, and that the sender does not accept liability
for any damages that may be incurred as a result of communication by e-mail.
No employee or intermediary is authorised to conclude a binding agreement on
behalf of the sender by e-mail without express written confirmation by a
duly authorised representative of the sender. By transmitting this e-mail
message over the Internet the sender does not intend to allow the contents
hereof to become part of the public domain, and the confidential nature of
the contents shall not be altered or diminished from by such transmission.

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

mysqld_multi - Cant find mysqld in my.cnf

[Mark Hewitt]

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 mysqld=xxx option in the [mysqld40009] section of my my.cnf file.

It simply complains it can't find a mysqld option!

[bin] ./mysqld_multi --no-log start 40009

MySQL 4.0.9 is installed in:
/usr/local/mysql/40009

Here is /etc/my.cnf:

[mysqld40009]
datadir=/usr/local/mysql/40009/data
socket=/usr/local/mysql/40009/mysql.sock
user=mysql
basedir=/usr/local/mysql/40009
port=3306
log=log
log-bin=binlog
mysqld=/usr/local/mysql/40009/bin/mysqld_safe


[mysqld_multi]


I can only get it to work when the mysqld= part is in a [mysqld_multi]
section, or on the command line. This is of course pointless, as I want each
server to run its own version. My mysqld_multi is version 2.5, which
according to the docs should be able to do this.

This does work for example:

[bin]./mysqld_multi --no-log --mysqld=/usr/bin/mysql/40009/bin/mysqld_safe -
-mysqladmin=/usr/bin/mysql/40009/bin/mysqladmin start 40009

Any ideas?

Mant thanks,
Mark
-
Windows, Linux and Internet Development Consultant
Email: [EMAIL PROTECTED]
Web: http://www.scriptsmiths.co.za
-


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