insert into specific row of table?

Anon

how do I insert into a specific row of a table? can't seem to get the correct syntax down.

INSERT INTO Ggerwyt (merURL) VALUES ('test.com') WHERE GgerID=12;

INSERT INTO Ggerwyt (merURL) VALUES ('test.com') SELECT GgerID=12;

I can do an insert from the command line with no problems without the WHERE or SELECT statements (i.e. not into a specific row), BUT, it creates a new row. Do I need to UPDATE the row? Syntax?
que?

many thanks!!
/frank

Anon

You will need to use the UPDATE function if you want to change or add something to an existing row i a database.

rgds,
scott d~

Anon

Hi Frank,

You are right, you must use an UPDATE statement to change the value of a column in a particular row.
The syntax is (taken from MySql.com):

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1,col_name2=expr2,...
[WHERE where_definition] [LIMIT #]

In your example, this would be:

UPDATE Ggerwyt SET merURL='test.com'
WHERE GgerID=12

Hope that helps!
Clarissa

Anon

thanks, that worked!!