FMDBsqilte语句样式

举例:

@"create table student(stuid integer primary key autoincrement,name text,number integer,theory float,skills float,remark text)"

 @"insert into student (name,number,theory,skills,remark) values(‘%@‘,‘%ld‘,‘%.1f‘,‘%.1f‘,‘%@‘)"

 @"delete from student where stuid=‘%ld‘"

 @"update student set name=‘%@‘,number=‘%ld‘,theory=‘%.1f‘,skills=‘%.1f‘,remark=‘%@‘ where stuid=%ld"

 @"select * from student"

 @"select * from student where stuid = 1"

FMDBsqilte语句样式

标签：