<?xml version="1.0" encoding="UTF-8" ?>

<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
    <title>Posteet: update</title> 
    <link>http://www.posteet.com/</link> 
    <description>Recent posteets posted to Posteet</description>
    <ttl>60</ttl>

    
    <item>
        <title>MySQL [UPDATE...IF NOT FOUND THEN...INSERT]</title>
        <link>http://www.posteet.com/view/826</link>
        <description>
        <![CDATA[<pre># MySQL has 2 methods for handling this:

REPLACE INTO people(id,name,email) VALUES (in_id, in_name, in_email);

INSERT INTO people(id,name,email) VALUES (in_id, in_name, in_email) ON DUPLICATE KEY UPDATE name='$in_name', email='$in_email';</pre> <a href="http://www.posteet.com/tags/insert">[insert]</a>  <a href="http://www.posteet.com/tags/mysql">[mysql]</a>  <a href="http://www.posteet.com/tags/update">[update]</a> ]]>        </description>
        <dc:creator>spirit</dc:creator>
        <pubDate>Mon, 10 Mar 2008 17:21:58 +0000</pubDate>

            <category>insert</category>
            <category>mysql</category>
            <category>update</category>
    
    </item>


</channel>
</rss>
