Problem with UPDATE in Mysql

[Anon]

Hello,

I just posted the question "Overwriting values in Mysql rows", and was given the answer to use UPDATE (thanks),

but I am now having a problem using that.
See I have currently used the command:
"USE CONTACTS"
and so now when I start using UPDATe by typing:
"UPDATE CONTACTS SET..."
I get the error message that table CONTACTS.CONTACTS already exists.

So how do I use update without specifing the table name, or overcome the problem of the table already being specified to be used earlier?

Thanks in advance, James.

[jariizumi]

Maybe you're getting DATABASE and TABLE mixed up... I take it that you have database CONTACTS and table CONTACTS.
In the console, this would be:

USE CONTACTS;
UPDATE CONTACTS SET age = 40 WHERE username = 'bob';

should do the job. If it's confused, it MIGHT be worth telling it that it's CONTACTS.age and CONTACTS.username, but that's unlikely.

And just as a general suggestion, don't use a table name that matches the database name or name a field the name of a table or database. Using different cases or giving it different titles makes things much easier for the table, especially when you start doing joins, etc.