ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pritesh saharey <prit...@sqatester.com>
Subject Running an Insert query
Date Sat, 20 Mar 2004 06:29:41 GMT
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


Mime
View raw message