LOAD data local INFILE 'F:/all-info/src/main/resources/test/data2.csv'
INTO
TABLE users FIELDS TERMINATED BY ',' LINES TERMINATED BY '/n' IGNORE 0 LINES (id,
name,
age);
data2.csv是这样的:
1,Alice,30/n2,Bob,25/n3,Charlie,35
local_infile参数:ON
TDSQL版本:5.7.35-V2.0R681D005-v17-20210125-2105-log
在Tidb中可以正常执行,在TDSQL中执行报错,错误如下:
SQL 错误 [1148] [42000]: The used command is not allowed with this MySQL version。
相似问题