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:
user 'username
> 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 and update
Hi Voytek
You could try some variation of:
INSERT INTO inserttable (user, maildir)
SELECT REPLACE(user, '@', 'spam@') as user, CONCAT(maildir,'.spam/')
as maildir
FROM selecttable
[WHERE ..]
the where bit is optional of course!
let me know how you go - hope you are keeping well!
ray
At 03
Hi all,
I would like to populate one column of my table with XML files -
meaning each element in that column will be an XML file. Is this
possible and how can it be done? Would it be more efficient to
store the files in the filesystem and instead keep a set of pointers
as elements in that colum
