1.将两个字段的值合并为一个
select column1||column2||... from table1
2.获取部分数据
select * from table1 limit 要显示多少条记录 offset 跳过多少条记录;或 select * from table1 limit 跳过多少条记录,要显示多少条记录;
3.创建表
create table SYS_User(
[ID] integer primary key autoincrement, /*自增*/
[LoginNumber] varchar(50),
[LoginPwd] varchar(50),
[Name] varchar(50),
[CreateDate] datetime default(datetime('now','localtime')) /*默认值*/
);
[ID] integer primary key autoincrement, /*自增*/
[LoginNumber] varchar(50),
[LoginPwd] varchar(50),
[Name] varchar(50),
[CreateDate] datetime default(datetime('now','localtime')) /*默认值*/
);
4.获取时间
>当前时间：select strftime('%Y-%m-%d %H:%M:%S','now','localtime')
>当前前一天：select strftime('%Y-%m-%d %H:%M:%S','now','localtime','-1 day')
>当前前一月：select strftime('%Y-%m-%d %H:%M:%S','now','localtime','-1 month')
