How to change a value in a column on a SQLite database?

Question

I have a SQLite database with this format:

TABLE users
    |
    |---------name - text
    |
    |---------avatar - text
    |
    |---------password - text
    |
    |---------userdir - text
    |
    |---------role - numeric

I want to change the number of role. How could I change it? (I mean, what query?)

I'm using PHP if anyone needs it. Thanks!

score 64 · Accepted Answer · answered Jul 21 '11 at 13:17

64

UPDATE users SET role=99 WHERE name='Fred'

answered Jul 21 '11 at 13:17

Graham Borland

58,983
20
134
177

How to change a value in a column on a SQLite database?

1 Answers1

Linked