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;
2 Antworten
0
What error you getting...?
May be int is enough instead Integer, not sure
0
never mind... i forgot to put ';' after "id = 1" ...