Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Perl DBI and Foreign Keys

by erix (Prior)
on Apr 08, 2019 at 13:00 UTC ( [id://1232295]=note: print w/replies, xml ) Need Help??


in reply to Perl DBI and Foreign Keys

Postgres has a RETURNING clause on the INSERT/UPDATE/DELETE statements ([1],[2]) which returns the inserted/updated/deleted values. Very handy.

Oracle and Firebird can do something similar.

Maybe lodge a complaint featurerequest with the MySql/MariaDB devs?

[1] - PostgreSQL INSERT

[2] - RETURNING

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (2)
As of 2024-04-25 04:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found