Re: sql to duplicate records with modified value

2010-04-27 Thread Voytek Eymont
se! > > let me know how you go - hope you are keeping well! > > ray > > At 03:17 PM 27/03/2010, Voytek Eymont wrote: > >> I have Postfix virtual mailboxes in MySQL table like below: >> >> >> I'd like to duplicate all records whilst MODIFYING two fi

Re: sql to duplicate records with modified value

2010-03-27 Thread Voytek Eymont
> Voytek Eymont wrote: > Are you hoping to do all that you want - copy rows, update rows and > create new rows - in a single SQL statement? Because if that's what you > want, I don't think it's possible. Unless someone has come up with some > new tricks, you

sql to duplicate records with modified value

2010-03-26 Thread Voytek Eymont
I have Postfix virtual mailboxes in MySQL table like below: I'd like to duplicate all records whilst MODIFYING two fields like so: current record has format like: user 'usern...@domain.tld' maildir 'domain.tld/usern...@domain.tld/' add new record that has: user 'username+s...@domain.tld' maildir

newbie installing MySQL/InnoDB on RH 7.1

2002-03-27 Thread Voytek Eymont
ot found on your system. Maybe MySQL is not installed, or your module configuration is incorrect. can this MySQL run as a server ? where is a client [root@charly /]# /etc/rc.d/init.d/mysqld start bash: /etc/rc.d/init.d/mysqld: No such file or directory [root@charly /]# clueless, V