Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

by davorg (Chancellor)
on Nov 29, 2000 at 00:41 UTC ( #43766=note: print w/ replies, xml ) Need Help??


in reply to Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

Surely this is only a problem if you use select * from tab1 and I can't believe that anyone would be stupid enough to do that in production code.

For exactly the reason that you discuss, you should always use select col1, col2 from tab1

The problem is not with Perl or DBI, but with your usage of SQL.

--
<http://www.dave.org.uk>

"Perl makes the fun jobs fun
and the boring jobs bearable" - me


Comment on Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (10)
As of 2014-08-20 19:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (122 votes), past polls