Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: DBI "drop table"

by DBAugie (Beadle)
on Apr 13, 2008 at 13:09 UTC ( #680077=note: print w/ replies, xml ) Need Help??


in reply to DBI "drop table"

Preface: My expertise is limited to Oracle. This is not necessarily applicable to other RDBMS.

placeholders work in statements like SELECT, DELETE, or UPDATE. These types of statements are known as data modification language (DML). DML changes data inside an object.

drop table is part of the data definition language. DDL actually changes the objects themselves.

Traditionally, database engines do not tolerate variables in DDL. Oracle has an "execute immediate" statement to add this functionality.

Perhaps mySql has a similar statement?

r,

Augie


Comment on Re: DBI "drop table"

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (12)
As of 2014-12-27 21:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

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





    Results (177 votes), past polls