Re: insert into specific row

Frank, Check out the UPDATE syntax in the MySQL manual. You probably need something like: UPDATE Ggerwyt SET MerURL = 'test.com' WHERE GgerID=12 Hope this helps. Cheers, Joel... --- Joel Sutton | Software Developer | jsutton@itworks.com.au ITworks Consulting | http://www.itworks.com.au/ Phone: +61+3+9642 5477 | Fax: +61+3+9642 5499 Melbourne, Australia | "Perl, PHP, MySQL, MS Access 97" On Wed, 6 Sep 2000, Franklin Hays wrote: > 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 > > --- Joel Sutton | Software Developer | jsutton@itworks.com.au ITworks Consulting | http://www.itworks.com.au/ Phone: +61+3+9642 5477 | Fax: +61+3+9642 5499 Melbourne, Australia | "Perl, PHP, MySQL, MS Access 97"