Challenge: Transaction Creation
Now, let's walk through creating a transaction ourselves based on the bank_accounts
table described in the previous chapter.
We're going to perform a straightforward financial transaction: transferring funds from one account to another. Ensuring that both steps occur as a single logical unit exemplifies a real-life transaction.
We will work with account numbers 101
and 789
and the initial balance will be the following:
Swipe to start coding
Your task is to fill in the gaps in the query to create a SQL transaction. Use the keywords BEGIN
and COMMIT
to do it.
Once you've completed this task, click the button below the code to check your solution.
Løsning
Takk for tilbakemeldingene dine!
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Awesome!
Completion rate improved to 4.35
Challenge: Transaction Creation
Sveip for å vise menyen
Now, let's walk through creating a transaction ourselves based on the bank_accounts
table described in the previous chapter.
We're going to perform a straightforward financial transaction: transferring funds from one account to another. Ensuring that both steps occur as a single logical unit exemplifies a real-life transaction.
We will work with account numbers 101
and 789
and the initial balance will be the following:
Swipe to start coding
Your task is to fill in the gaps in the query to create a SQL transaction. Use the keywords BEGIN
and COMMIT
to do it.
Once you've completed this task, click the button below the code to check your solution.
Løsning
Takk for tilbakemeldingene dine!
Awesome!
Completion rate improved to 4.35single