How to rectify a wrong entry?

satimis · #1 (**permalink**) 04-16-11, 12:29

Hi folks,

I ran following commands
mysql> USE AAADatabase

mysql> INSERT INTO domains VALUES ('www.aab.org','/var/www/www.aaa.net/web/');

It should be;

Code:

INSERT INTO domains VALUES ('www.aaa.net','/var/www/www.aaa.net/web/');

Please advise how to correct it? TIA

B.R.
satimis

shammat · #2 (**permalink**) 04-16-11, 12:31

Code:

UPDATE domains
   SET the_unknown_column = 'www.aaa.net'
 WHERE the_unknown_column = 'www.aab.org';

More details in the manual: http://dev.mysql.com/doc/refman/5.5/en/update.html

satimis · #3 (**permalink**) 04-16-11, 12:42

Quote:

Originally Posted by shammat

Code:

UPDATE domains
   SET the_unknown_column = 'www.aaa.net'
 WHERE the_unknown_column = 'www.aab.org';

More details in the manual: MySQL :: MySQL 5.5 Reference Manual :: 12.2.11 UPDATE Syntax

Hi,

Thanks for your advice and link.

mysql> UPDATE domains
-> SET the_unknown_column = 'www.aaa.net'
-> WHERE the_unknown_column = 'www.aab.org';
ERROR 1054 (42S22): Unknown column 'the_unknown_column' in 'where clause'

B.R.
satimis

healdem · #4 (**permalink**) 04-16-11, 13:11

so what did you call the column that contained 'www.aaa.com'
shammat was saying he didn't know and called it 'the_unknown_column'

if it was called hosts
so that would read
update domains set hosts = 'www.aab.net' where hosts = 'www.aab.org';

shammat · #5 (**permalink**) 04-16-11, 13:26

Quote:

Originally Posted by satimis

mysql> UPDATE domains
-> SET the_unknown_column = 'www.aaa.net'
-> WHERE the_unknown_column = 'www.aab.org';
ERROR 1054 (42S22): Unknown column 'the_unknown_column' in 'where clause'

That'll teach you to always post the correct table definitions.