DBI delete or truncate ?

[donny750]

Hello,

I want to use perl DBI to make this query
truncate table FIRM;

It's possible with perl DBI to do this ?

Thanks

 

[MacTommy]

Why wouldn't it?!?

You just say

$sth = $dbh->prepare("TRUNCATE TABLE FIRM");

$sth->execute();

Or do you mean something else..?!?

 

[donny750]

ok
it's good
firstly i mean that perl DBI can just make :select,insert,update

 

[cdlvj]

As MacTommy indicated you can do any sql statements. But you do have to have the authorization to do so. Usually users only have select, insert, update, delete.