in reply to rows affected by an update command

The answer you are seeking for is probably database dependent. I would say "what would happen" isn't a Perl question, it's a database question. The DBI would return as the number of rows affected whatever number the database returns.

So, short of trying it out in your database, I suggest you consult the manuals of your database server. Or have a chat with your friendly neighbourhood database administrator.

Replies are listed 'Best First'.
Re^2: rows affected by an update command
by Anonymous Monk on Nov 02, 2010 at 15:18 UTC
    I don't have one of those :)

    If i run this query as a prepared statement, is there a way to print out the query that has been executed?
[reply]

      See the TRACING section in the DBI documentation.

      -- Ken

[reply]

        To be pedantic, DBI tracing will show you only what was passed to the database, not what was actually executed.

        Missing manuals should be no problem for most databases. Those of SQLite, PostgreSQL and MySQL are freely available and complete on the WWW. For MS SQL Server, Oracle, and DB2, you will also find most of the documentation on the WWW, either at Microsoft/Oracle/IBM, or at some website that ignores the copyright on those documents. In all cases, Google should be able to find the documentation.

        Alexander

        --
        Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
[reply]
      I don't have one of those :)
      If you don't have a database to try it out with, does it really matter what it returns? ;-)
[reply]

        He doesn't have a "friendly neighbourhood database administrator".

[reply]

In Section Seekers of Perl Wisdom