CREATE TABLE db_User(
[Id] INTEGER PRIMARY KEY,
[UserName] [nvarchar](50),
[Phone] [nvarchar](50),
[Deleted] [int],
[PostTime] [datetime]
)
主键后面加 INTEGER PRIMARY KEY
增加数据时,针对主键列,不赋值,主键列会自动增长
CREATE TABLE db_User(
[Id] INTEGER PRIMARY KEY,
[UserName] [nvarchar](50),
[Phone] [nvarchar](50),
[Deleted] [int],
[PostTime] [datetime]
)
增加数据时,针对主键列,不赋值,主键列会自动增长