how to truncate table?

Ranch Hand

Posts: 121

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I need to truncate the table before inserting new record into my table, can anyone tell me the syntax?
Is this right?
Statement stTruncate = con.createStatement();
stTruncate.executeUpdate("truncate table tblName");
???
Thanks!

Mindy Wu

Ranch Hand

Posts: 121

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Never mind, i did it. The above code is right!

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?