Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Ant Users List" <user@ant.apache.org>
Content-Type: text/plain; charset="UTF-8"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0
Date: Sun, 21 Mar 2004 20:52:03 -0800 (PST)
From: Pritesh saharey <pritesh@sqatester.com>
To: "Ant Users List" <user@ant.apache.org>
Subject: RE: Running an Insert query
Reply-To: pritesh@sqatester.com
Message-Id: <20040322045203.C3FB1396C@sitemail.everyone.net>

Thanks Marco but i didnt get you can you elobrate more if possible


Pritesh Saharey
BE(Mech)
Software Engineer


--- "Marco Rouse" <webmaster@servimx.net.mx> wrote:

First run myisamchk and set the auto-increment value you want to
start with -A or --set-auto-increment[=3Dvalue]=C2=A0then set the value
of the auto increment column in the insert to null.


-----Mensaje original-----
De: Matt Benson [mailto:gudnabrsam@yahoo.com]=20
Enviado el: S=C3=A1bado, 20 de Marzo de 2004 12:37 p.m.
Para: Ant Users List; pritesh@sqatester.com
Asunto: Re: Running an Insert query

I don't know about MySQL, but in Oracle you would use
something called a "sequence" and reference it in your
query to set the next value.  I would imagine that the
MySQL developers would have implemented something
similar.

-Matt

--- Pritesh saharey <pritesh@sqatester.com> wrote:
> Hi All,
>      I would like to insert atleast 50,000 records
> in database, there is a Ticket_ID field which is
> unique and autogenerated like this 104031000001,
> 104031000002 ....,=20
> what should i do in my build.xml file to run an
> Insert query (database is Mysql), the query can be
> like this
> INSERT INTO moviecan
> VALUES(104031000001,'Naseeb','Hope','2004-03-18
> 11:19:55',100,2500,25,0,1,1,'U',2,2,'2004-03-18
> 11:23:13');
>=20
> I would like to get different Ticket_ID in
> incremental form like this 104031000001,
> 104031000002, 104031000003 ...., for every Insert
> query
>=20
> can anybody help me out
>=20
> thanks in advance
> wishes
> pritesh
>=20
>=20
>=20
>=20
>=20
>=20
>
_____________________________________________________________
> Join SQAtester.com Community  --->
> http://www.sqatester.com/testersarea/joinus.htm
>=20
>
-----------------------------------------------------------------
----
> To unsubscribe, e-mail:
> user-unsubscribe@ant.apache.org
> For additional commands, e-mail:
> user-help@ant.apache.org
>=20


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

-----------------------------------------------------------------
----
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


_____________________________________________________________
Join SQAtester.com Community  ---> http://www.sqatester.com/testersarea/joi=
nus.htm

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org