文件名:1111.ctl文件内容:LOAD DATA
INFILE '/test/test.txt'
TRUNCATE
INTO TABLE test
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
FIELD1 ,
FIELD2 ,
FIELD3 ,
FIELD4
)
已知数据库连接对象 conn ,请问下怎么在代码中执行导入啊?
INFILE '/test/test.txt'
TRUNCATE
INTO TABLE test
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
FIELD1 ,
FIELD2 ,
FIELD3 ,
FIELD4
)
已知数据库连接对象 conn ,请问下怎么在代码中执行导入啊?
因为我是用的框架可以直接获得当前数据库连接。
而里面的这三个内容随着发布环境不同是会改变的
最后....怎么改问题的分值,40分少了点