mysql insert query?

Question

Hi,

I need a query that INSERTS the word 'yes' into the field 'taken' WHERE name = $currentname

what is the correct syntax?

Thanks!

Answer 1

UPDATE YourTable SET taken='yes' WHERE name='$currentname'; // YourTable is the table name

Answer 2

the only element i'm going to propose is attempt removing one field at a time from the insert reality, and notice at what element it starts working. Then that field is your concern. it particularly is complicated paintings extensive, even even in spite of the shown fact that it particularly is the only thank you to pass.

Answer 3

Since the record in question exists, you need to do an update statement rather than an insert.

UPDATE table_name
SET field_name = "Yes"
WHERE name = $currentname

Answer 4

I keep seeing more elementary questions from you...
You do not seem to take in consideration what users tell you.
And you really need to learn "seriously" about MySQL: your querries are those of real beginner.
Learn first.

Answer 5

i think .. it's update command because there is where
here is the command :
update ttable set taken values 'yes' where name=$currentname;

by
http://www.gunungpring.com

Answer 6

i think u need the update command and not insert

UPDATE table_name //change TABLE NAME !!!
SET taken = yes
WHERE name = $currentname