从文件csv导入db2(db2 import from file csv)
我做了一个简单的例子,但它不起作用。 我连接到示例数据库
我的文件是ABC.csv
1; 2
2; 3
db2 import from "ABC.csv" OF DEL insert into abc(id,id2)
导入找到行,它说插入。
但是如果db2 select * from abc没有数字出现但是' - '
例
id id2
_ _
_ _
为什么?
表abc创建为(id int,id2 int)
I made a simple example, but it does not work. I connect to sample database
my file is ABC.csv
1;2
2;3
db2 import from "ABC.csv" OF DEL insert into abc(id,id2)
the import found the rows and it says that inserted.
but if db2 select * from abc no numbers appear but '-'
example
id id2
_ _
_ _
why?
the table abc is create as (id int, id2 int)
原文:https://stackoverflow.com/questions/35553959
更新时间:2