INSERT statement in MySQL

al.

Hi, i've been at this SQL problem for ages and i cannot find a solution yet it seems like an extremely trivial problem. I have a database with three columns in it Name, Price and Count. I am trying to insert a value to the count column where name = 'some value'. I have tried so many different ways of doing this but i keep on getting a 'check SQL Syntax error'. I can do it using referencing when i break the table up into two tables with Name, Price and Name Count as the columns but i need to keep it as one table. Does anybody have any ideas? I've been trying many variations of:

INSERT into tablename(count)
VALUES('12')
WHERE Name = 'some value';

pan

for one, remove the ";" from the end of the statement and try it.
Also make sure if your are inserting integer values, that the corresponding table in the database also stores the data as integers i.e. if stored as strings then you would get an error.

pan

bonkey

That should be an UPDATE statement.

INSERT is for adding rows. You can't add a row WHERE some matching criteria is satisfied

You UPDATE a row WHERE some matchnig criteria is satisfied.

BizzyC

bonkey wrote:

That should be an UPDATE statement.

INSERT is for adding rows. You can't add a row WHERE some matching criteria is satisfied

You UPDATE a row WHERE some matchnig criteria is satisfied.

Hit the nail on the head.

amen

you should avoid using SQL keywords such as Count for column names instead why use something like ProductCount or NumItems etc

al.

Cheers Bonkey that was driving me nuts, thanks for the advice amen ill use sonething other than count