Re: sql to duplicate records with modified value

2010-04-27 Thread Voytek Eymont
/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 fields like so: current record has format like: user 'usern...@domain.tld' maildir 'domain.tld/usern...@domain.tld/' add new record that has

Re: sql to duplicate records with modified value

2010-03-27 Thread Voytek Eymont
quote who=Rhino 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 can't insert a new record

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'

newbie installing MySQL/InnoDB on RH 7.1

2002-03-27 Thread Voytek Eymont
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, Voytek Eymont http://www.sbt.net.au/links