sqlite3 - fuchu @ ウィキ

sqlite3 cmd

table参照

.tables

.tables

table詳細

.schema <table name>

.schema user

pragma table_info('<table name>')

pragma table_info('user')

sql cmd

table作成

create table <table name> (<column1> primary key, <column2>,…);

create table user (id int primary key, name text);

record追加

insert into <table name> values (<column1 value>,<column2 value>,…);

insert into user values (1,'nagamine');

column追加

alter table <table name> add column　<column>;

alter table user add column sex text;

record更新

update user set <column>=<value> where <condition>;

update user set sex='m' where id=1;

record一括更新

update user set <column>=<value>

update user set sex='m'

table削除

drop table <table name>;

drop table user;