Re: insert into specific row

FrankLin, Just as a side note the /usr/doc/MySQL-x.xx.x/manual.txt (comes with MySQL) is the most useful piece of documentation for MySQL in the world ever. It's what I learnt MySQL from. Cheers, David. ----- Original Message ----- From: Franklin Hays <frank@kyk.als.orst.edu> To: <php-db@lists.php.net> Sent: Thursday, September 07, 2000 4:03 AM Subject: [PHP-DB] insert into specific row > > > quick question which I can't find the answer to, how can I insert data > into a specific row of a table? > > I have tried : > INSERT INTO Ggerwyt (merURL) VALUES ('test.com') WHERE GgerID=12 > INSERT INTO Ggerwyt (merURL) VALUES ('test.com') SELECT GgerID=12 > WHERE GgerId='12' INSERT INTO Ggerwyt (merURL) VALUES ('test.com'); > > no luck... > > I can do the generic INSERT from the command line without the WHERE part > (GgerID=12) but it creates a NEW row and inserts the value. > > I can do the insert from PHPMyAdmin but it doesn't show the syntax for the > command. :-( > > do I need to use UPDATE or some other method? > > TIA, > /frank > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >