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

Ashur_4512014-05-13 22:12:30

How to create an Entity Data Model using SQLite in Visual Studio 2013? 0Reply

I

Ivan Kostyuk2018-11-20 22:37:39

How to group records by interval in sqlite? 1Reply

U

uzolenta2018-12-02 22:48:19

Insert, delete sqlite not working on device? 0Reply

A

AleksandrFl2020-10-03 15:55:08

How to build a visual studio CMake project using SQLite? 1Reply

S

SerjLore2020-10-04 20:29:08

When selecting data in sqlite3 and with fetchone, None comes out, although everything is fine in the db browser? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question