PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WEBDEV 2024 → Commands in SQL
Commands in SQL
Débuté par Aarti Yadav, 05 juin 2020 11:09 - 2 réponses
#1
Posté le 05 juin 2020 - 11:09
Hello Everyone, I am new in this community and I want to now about TCL command in SQL, what types of types I can run into it? I want to know about COMMIT, ROLLBACK and SAVEPOINT syntax. Can anyone tell me what's the syntax of these commands?
#2
Membre enregistré
31 messages
Popularité : +1 (1 vote)
Posté le 05 juin 2020 - 13:07
Hi Aarti,

You may want to check the help on these commands:

HTransactionStart
HTransactionCancel
HTransactionEnd

Hope that helps

Femi
#3
Posté le 08 juin 2020 - 15:01
Here your answer, How you can use all these three commands:

INSERT INTO class VALUES(5, 'Rahul');

COMMIT;

UPDATE class SET name = 'Abhijit' WHERE id = '5';

SAVEPOINT A;

INSERT INTO class VALUES(6, 'Chris');

SAVEPOINT B;

INSERT INTO class VALUES(7, 'Bravo');

SAVEPOINT C;

SELECT * FROM class;

To know more visit here: https://hackr.io/blog/sql-commands
→ Revenir à WEBDEV 2024