[转载] sql question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

[转载] sql question

[转载] sql question# Java - 爪哇娇娃

b*o2004-03-06 08:03

1 楼

【以下文字转载自 Software 讨论区,原文如下】
发信人: bolero (ripple), 信区: Software
标题: sql question
发信站: Unknown Space - 未名空间 (Fri Mar 5 09:16:43 2004) WWW-POST
i wanted to create a table, but one field name is "local", and the system does
not allow me to do that in sql
"create table MyTable (id integer, local varchar)".
Anybody knows how to avoid the confliction? Thanks a lot!!

z*g2004-03-06 08:03

2 楼

local may be a reserved keyword. YOu can't use it.
Just rename local to something else.

【在 b****o 的大作中提到】

: 【以下文字转载自 Software 讨论区,原文如下】
: 发信人: bolero (ripple), 信区: Software
: 标题: sql question
: 发信站: Unknown Space - 未名空间 (Fri Mar 5 09:16:43 2004) WWW-POST
: i wanted to create a table, but one field name is "local", and the system does
: not allow me to do that in sql
: "create table MyTable (id integer, local varchar)".
: Anybody knows how to avoid the confliction? Thanks a lot!!