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