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


i have sqlite database format:

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

i want change number of role. how change it? (i mean, query?)

i'm using php if needs it. thanks!

update users set role=99 name='fred' 

Comments

Popular posts from this blog

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -