Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Deleting all from all tables in MYSQL

by herveus (Parson)
on Sep 19, 2012 at 17:00 UTC ( #994480=note: print w/ replies, xml ) Need Help??


in reply to Deleting all from all tables in MYSQL

Howdy!

You can't use placeholders that way. MySQL can't parse a statement like "delete from ?", so you can't prepare it. You are pretty much stuck with "delete from $row[0]".

yours,
Michael


Comment on Re: Deleting all from all tables in MYSQL
Re^2: Deleting all from all tables in MYSQL
by justin423 (Initiate) on Sep 19, 2012 at 17:12 UTC
    Thanks. So would this work instead?
    my $query = $dbh->prepare('SHOW TABLES'); if (defined($query)) { $query->execute(); my @row; while (@row = $query->fetchrow_array()) { $sql = qq|delete from $row[0]|; $sth = $dbh->prepare($sql) or die "Cannot prepare: " . $dbh->errstr(); $sth->execute() or die "" . $sth->errstr();

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://994480]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2014-12-26 10:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (171 votes), past polls