From Wiki

(Difference between revisions)
Jump to: navigation, search
Admin (Talk | contribs)
(Usage of SQLite to edit, update and modify a sqlite database.)
Newer edit →

Revision as of 12:02, 20 February 2012

Using SQLite

#Open SQLite database
sqlite databasefile

#List tables

#Desc tables
.schema users

select * from users;

#Update table
update users set email="test@test.com" where email="wrongemail@test.com";

#Delete row
delete from users where user_id=5;

Refs: http://www.pantz.org/software/sqlite/sqlite_commands_and_general_usage.html

Personal tools