nixCraft

satimis · #1 (**permalink**) 22-05-2009, 07:22 AM

Hi folks,

Ran following command to create aliases table

Code:

mysql> CREATE TABLE `aliases` (
    -> `pkid` smallint(3) NOT NULL auto_increment,
    -> `mail` varchar(120) NOT NULL default '',
    -> `destination` varchar(120) NOT NULL default '', 
    -> `enabled` tinyint(1) NOT NULL default '1',
    -> PRIMARY KEY (`pkid`),
    -> UNIQUE KEY `mail` (`mail`)
    -> ) ;
Query OK, 0 rows affected (0.01 sec)

And ran following command to enter data

Code:

mysql> INSERT INTO aliases (mail,destination) VALUES
    -> ('albert@abc.com','albert@abc.com'),

Now I need to change "albert@abc.com" to "albertlee@abc.com" running following command without sucess

Code:

mysql> ALTER aliases CHANGE 'albert@abc.com', 'albertcheung@abc.com' varchar(120) ;

mysql> ALTER aliases CHANGE 'albert@abc.com' 'albertcheung@abc.com' ;

mysql> ALTER aliases CHANGE 'albert@abc.com', 'albertcheung@abc.com' ; 
etc.

Always syntax error.

Please advise what will be the correct syntax? TIA

Will MODIDY be the same as CHANGE?

Can I use DROP to erase this email address? If YES please advise how?

B.R.
satimis

kasimani · #2 (**permalink**) 22-05-2009, 11:41 AM

use this method

Code:

 UPDATE aliases SET 'mail' = 'albertcheung@abc.com' WHERE 'aliases'.'pkid' =1;

satimis · #3 (**permalink**) 22-05-2009, 12:01 PM

Quote:

Originally Posted by kasimani

use this method

UPDATE aliases SET 'mail' = 'albertcheung@abc.com' WHERE 'aliases'.'pkid' =1;

Hi kasimani,

Thanks for your advice.

What is

Code:

'aliases'.'pkid' =1

?

Please explain in detail. Thanks

B.R.
satimis

nixcraft · #4 (**permalink**) 23-05-2009, 04:26 PM

You are matching field with where option. Please read SQL statement or syntax below:
MySQL :: MySQL 5.0 Reference Manual :: 12.2.11 UPDATE Syntax

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to check "incorrect mails" before sending it through my mail server?	nishith	Mail Servers	1	28-04-2009 01:41 AM
Redhat: Up2date " permission denied" while root	guarrand	Getting started tutorials	2	03-07-2008 11:50 AM
Does Redhat have "what" utility which can be used to display identification Info?	DCAO	Linux software	2	30-10-2007 07:23 PM
[Commercial] SafeSquid "SPEED-BOOSTER" 4.2.0 Released	httpproxy	Networking, Firewalls and Security	1	26-09-2007 08:05 PM
iptables with "! --syn" question	kkruecke	Linux software	3	31-10-2006 07:34 PM

nixCraft

Question - Syntax on "CHANGE"

Question - Syntax on "CHANGE"

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads