Home : Products : Gossamer Mail : Discussion :

Products: Gossamer Mail: Discussion: Re: [baidarkabob] location of address book files: Edit Log

Here is the list of edits for this post
Re: [baidarkabob] location of address book files
Hi Bob,

If you're moving the addresses from one user to another, you would use an UPDATE query. (MySQL UPDATE Syntax)

Something like this *should* work:

Code:
UPDATE webmail_address
SET address_userid = 'new_user_id'
WHERE address_userid = 'old_user_id'

Your table prefix may be different.

NOTE: I did not test this. I would make a copy of the table and test it before running the query.

[edit]
Bob: Are you actaually moving the addresses from one database to another? If so, this query won't work for you.
[/edit]

Regards,
Charlie

Last edited by:

Chaz: Apr 28, 2003, 10:11 AM

Edit Log: