Return-Path: 
 <user-java-return-12233-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 18252 invoked from network); 5 Aug 2007 16:16:12 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 5 Aug 2007 16:16:12 -0000
Received: (qmail 11348 invoked by uid 500); 5 Aug 2007 16:16:05 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 11328 invoked by uid 500); 5 Aug 2007 16:16:05 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 11317 invoked by uid 99); 5 Aug 2007 16:16:05 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Aug 2007 09:16:05 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.146.183 as permitted sender)
Received: from [209.85.146.183] (HELO wa-out-1112.google.com) (209.85.146.183)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Aug 2007 16:16:02 +0000
Received: by wa-out-1112.google.com with SMTP id j5so1730872wah
        for <user-java@ibatis.apache.org>;
 Sun, 05 Aug 2007 09:15:42 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=oujxv+36p/aNAAPNMMROiT7cmJ01WdyWiKI544baj895J3ZnCh07EIvRkVF9WbQhnHvTVetU4PkLIS+WsghQ7AhpKnEMBO7Yx/Dqf/XnudDB+SrFvcCeuaROn+jiPgXv1md08gnvgg7wytlfssWygV+sSWZMIFGqIA4IpM0OosQ=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=kC3gNXD8G4aUW10D0Qq3bvHLD9FASn8R6yBmfSKSMf14xr2++4nJktlxIMD+ypynaAxSYekj7LFY6Ps60HSblqm6W/+ON+s4kJSwtD+Lh2879FZt+SrNo3hxtXaRnSYwQN0iN0wEXT6s7H8gcGG3RvSCYFuvl3OG81Xwl4c9lXU=
Received: by 10.114.60.19 with SMTP id i19mr4792245waa.1186330541857;
        Sun, 05 Aug 2007 09:15:41 -0700 (PDT)
Received: by 10.115.93.20 with HTTP; Sun, 5 Aug 2007 09:15:41 -0700 (PDT)
Message-ID: <16178eb10708050915s6b56bb97t3369f3170fc8420e@mail.gmail.com>
Date: Sun, 5 Aug 2007 10:15:41 -0600
From: "Clinton Begin" <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: How to insert a row into MySQL?
In-Reply-To: <C2DB9BE8.50991%zoran@sparecreative.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_86655_1549520.1186330541828"
References: <11998476.post@talk.nabble.com>
	 <C2DB9BE8.50991%zoran@sparecreative.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_86655_1549520.1186330541828
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I'm guessing that you'd also be interested in how to get that ID back....

Check out page 20 in the Developer Guide.

http://ibatis.apache.org/javadownloads.cgi

Clinton

On 8/4/07, Zoran Avtarovski <zoran@sparecreative.com> wrote:
>
> Just do a standard insert and don't include the id column.
>
> >
> > Hi.
> > How to insert a new record in MySQL table in the case that the table
> uses an
> > auto
> > generated ID column?
> > Thanks.
>
>
>

------=_Part_86655_1549520.1186330541828
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I&#39;m guessing that you&#39;d also be interested in how to get that ID back....<br><br>Check out page 20 in the Developer Guide.<br><br><a href="http://ibatis.apache.org/javadownloads.cgi">http://ibatis.apache.org/javadownloads.cgi
</a><br><br>Clinton<br><br><div><span class="gmail_quote">On 8/4/07, <b class="gmail_sendername">Zoran Avtarovski</b> &lt;<a href="mailto:zoran@sparecreative.com">zoran@sparecreative.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Just do a standard insert and don&#39;t include the id column.<br><br>&gt;<br>&gt; Hi.<br>&gt; How to insert a new record in MySQL table in the case that the table uses an<br>&gt; auto<br>&gt; generated ID column?<br>&gt; Thanks.
<br><br><br></blockquote></div><br>

------=_Part_86655_1549520.1186330541828--