ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pritesh saharey <prit...@sqatester.com>
Subject RE: Running an Insert query
Date Mon, 22 Mar 2004 04:52:03 GMT
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[=value] then set the value
of the auto increment column in the insert to null.




-----Mensaje original-----
De: Matt Benson [mailto:gudnabrsam@yahoo.com] 
Enviado el: Sábado, 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 ...., 
> 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');
> 
> I would like to get different Ticket_ID in
> incremental form like this 104031000001,
> 104031000002, 104031000003 ...., for every Insert
> query
> 
> can anybody help me out
> 
> thanks in advance
> wishes
> pritesh
> 
> 
> 
> 
> 
> 
>
_____________________________________________________________
> Join SQAtester.com Community  --->
> http://www.sqatester.com/testersarea/joinus.htm
> 
>
-----------------------------------------------------------------
----
> To unsubscribe, e-mail:
> user-unsubscribe@ant.apache.org
> For additional commands, e-mail:
> user-help@ant.apache.org
> 


__________________________________
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/joinus.htm

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


Mime
View raw message