|
|
| |
|
| |
| |
| ACCESS 中使用sql 语句创建表 |
|
[ 2012-1-10 13:44:00 | By: gaoxiaopeng ] |
Create TABLE [MyTable]
(id counter primary key,
[title] string(250),
[content] MEMO,
[times] DATETIME,
[score] INTEGER,
[author] VARCHAR(50),
[link] VARCHAR(250),
newsId INTEGER,
score0 INTEGER,
score1 INTEGER,
score2 INTEGER,
score3 INTEGER,
score4 INTEGER
)
Create TABLE [YC_Class]
(id counter primary key,
[yc_newsid] INTEGER,
[yc_pl_bm] INTEGER,
[yc_pl_loginid] VARCHAR(20),
[yc_pl_person] VARCHAR(10),
[pl_content] MEMO,
score INTEGER,
[times] DATETIME,
[tag] VARCHAR(50)
)
Create TABLE [YC_News]
(id counter primary key,
[loginId] VARCHAR(50),
[loginName] VARCHAR(50),
[personType] VARCHAR(20),
[readNum] INTEGER,
[readTime] DATETIME,
NoReadNum INTEGER,
[NewsIds] MEMO
)
类型解说
MEMO 备注
INTEGER, 数字
DATETIME, 日期
VARCHAR(50), 文本
counter primary key, 自增 主键
此文档来自世界服装鞋帽网技术支持部 严禁转载
|
|
| | |
|
