Android database _ SQL statement summary, android_ SQL

Android database _ SQL statement summary, android_ SQL

Table Creation
Db.exe cSQL ("create table info (_ id integer primary key autoincrement, name varchar (20 )");

Db.exe cSQL ("alter table info add phone varchar (20 )");


Add, delete, modify, and query SQL statements

-- Insert into info (name, phone) values ('wang wu', '123 ');
-- Delete from info where name = 'wang wu ';
-- Update info set phone = '000000' where name = 'wang wu ';
-- Select name, phone from info


------------------------------
Database transactions
Db.exe cSQL ("create table info (_ id integer primary key autoincrement, name varchar (20), phone varchar (20), money varchar (20 ))");
Db.exe cSQL ("insert into info ('name', 'phone', 'money') values ('zhang san', '123', '123 ')");
Db.exe cSQL ("insert into info ('name', 'phone', 'money') values ('lily', '123', '123 ')");





Db.exe cSQL ("update info set money = money-200 where name =? ", New String [] {" AA "});
// Int I = 100/0;
Db.exe cSQL ("update info set money = money + 200 where name =? ", New String [] {" BB "});