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.
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.