0

whats the problem?

BEGIN TRANSACTION; CREATE TABLE NAMES(Id integer PRIMARY KEY, Name text); INSERT INTO NAMES VALUES(1,'Tom'); INSERT INTO NAMES VALUES(2,'Lucy'); INSERT INTO NAMES VALUES(3,'Frank'); INSERT INTO NAMES VALUES(4,'Jane'); INSERT INTO NAMES VALUES(5,'Robert'); COMMIT; UPDATE NAMES SET Name = "HELLO" WHERE Id = 1 SELECT * FROM NAMES;

9th Sep 2020, 8:27 PM
Yahel
Yahel - avatar
2 Antworten
0
What error you getting...? May be int is enough instead Integer, not sure
9th Sep 2020, 9:18 PM
Jayakrishna 🇮🇳
0
never mind... i forgot to put ';' after "id = 1" ...
10th Sep 2020, 12:55 PM
Yahel
Yahel - avatar