How to change the value of a column with text in a SQlite3 database?

X

X

Xacker_Name2021-10-09 16:24:11

SQLite

Xacker_Name, 2021-10-09 16:24:11

How to change the value of a column with text in a SQlite3 database?

How to change the value of a column with text in a SQlite3 database?

Let's say I have a table:

id    nik
1     test
2     test2
3     test3

How can I change the nik column with id value 2 to be valid for test4 instead of test2?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Sergey Gornostaev, 2021-10-09
@rt2233

Just execute the update request with the condition id = 2.

Similar questions

A

Alexey2015-01-26 20:44:53

Simultaneous access to one sqlite db, is it possible? 1Reply

A

Andriy Muzyka2017-02-12 11:51:59

android how to load existing sqlite db? 1Reply

L

le1T2019-07-13 23:24:51

How to save the sent telegram audio file to the bot in the database? 0Reply

B

Boris the Animal2015-02-14 03:03:16

SQLite Entity Framework 6. Can't find provider. Does not create a table, even if it creates a database. What is the reason? 0Reply

T

tsul2015-02-17 05:12:26

Is there a SQLite database manager with custom DATETIME view capability? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question