SQLITE3 与ORACLE异同不同操作总结
1. SQLITE检查表是否存在
select count(*) cnt from sqlite_master where type=’table’ and name=’aaa’
2. 创建自增类型的字段,写法为
id integer primary key autoincrement
3. SQLITE日期操作语法(date,time,datestamp)
select * from Placard where Placard_EndTime > datetime(‘now’);
SELECT Placard_StartTime,strftime(‘%s’,Placard_StartTime) ......