Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Perl DBI and Foreign Keys

by erix (Parson)
on Apr 08, 2019 at 13:00 UTC ( #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

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (3)
As of 2019-11-17 03:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (85 votes). Check out past polls.
    Notices?