urgent help! insert value into table - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

urgent help! insert value into table

urgent help! insert value into table# Database - 数据库

c*t2003-03-21 08:03

1 楼

What is the sql command for inserting values into a table?
The table has just one column called id, which is double type.
The id is unique. If I insert bunch of id's into the table,
some of might be duplicate. What to do in that case?
Thanks

n*m2003-03-21 08:03

2 楼

when you create the table, you can specify col as UNIQUE.
But I am not very sure whether it will work on double data

【在 c*****t 的大作中提到】

: What is the sql command for inserting values into a table?
: The table has just one column called id, which is double type.
: The id is unique. If I insert bunch of id's into the table,
: some of might be duplicate. What to do in that case?
: Thanks

xt2003-03-21 08:03

3 楼

What do you mean? Table with only 1 column? you can do
CREATE TABLE T ( value FLOAT NOT NULL, PRIMARY KEY( value ) )

s*a2003-03-21 08:03

4 楼

use either primary key or unique to make sure there is no dupicate values.

【在 c*****t 的大作中提到】

c*t2003-03-21 08:03

5 楼

That's not what I meant. I meant that I have a existing SQL table
called Queue. It has a single column id. Given this table, I now
have a bunch of ids to put into the table. Yet, these ids may be
duplicated. The question is how to avoid the duplicate and at
the same time be as efficient as possible.
Thanks

【在 s*a 的大作中提到】

: use either primary key or unique to make sure there is no dupicate values.

f*g2003-03-21 08:03

6 楼

Hope this query can work for the case:
INSERT INTO Queue (ID) SELECT @input_ID WHERE NOT EXISTS(SELECT * FROM Queue WHERE ID = @input_ID)

【在 c*****t 的大作中提到】

: That's not what I meant. I meant that I have a existing SQL table
: called Queue. It has a single column id. Given this table, I now
: have a bunch of ids to put into the table. Yet, these ids may be
: duplicated. The question is how to avoid the duplicate and at
: the same time be as efficient as possible.
: Thanks