Delete data from a database

The database before delete


Frame> printP
    0 "John Doe" 0
    1 "Jane Doe" 0
    2 "Steve Black" 1
    3 "Jack Farmer" 2



removeJack =
    withDB $ \ db ->
    delete db P.farmers (\r-> r!P.farmer_id .==. constant 3)


Frame> removeJack


The database after delete


Frame> printP
    0 "John Doe" 0
    1 "Jane Doe" 0
    2 "Steve Black" 1


if you get an error see this page
also see insert
What's that P?

Here are all words and functions with references, in alphabetical order

Go to main page