离,路的尽头还很远...

SQLite的日期操作:SQLite支持五中日期时间函数, 如下:1. date(timestring, modifier, modifier, ...) 2. time(timestring, modifier, modifier, ...) 3. datetime(timestring, modifier, modifier, ...) 4. julianday(timestrin

--创建表: SL_Register_InfoCREATE TABLE [SL_Register_Info] ( [RegID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [UserID] INT NOT NULL CONSTRAINT [ForeingKey_UserID] REFERENCES [SL_User_Info]([UserI

SELECT CASE RegType WHEN 1 THEN '月卡' WHEN 0 THEN '周卡' WHEN 2 THEN '季度卡' WHEN 3 THEN '年卡' ELSE '未知卡类型'