* Joel Wickard > I need to write a query that will insert data into a table if there is no > row matching a pre-specified ID, but will update a row if it matches a > pre-specified ID. > > Any pointers would be great.
The REPLACE statement: <URL: http://www.mysql.com/doc/R/E/REPLACE.html > -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php