b****o
发帖数: 55 | 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****g
发帖数: 2497 | 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!!
|
|
