LOAD DATA LOCAL INFILE语句中文乱码在Deepseek、豆包、千问中对错测评。

Deepseek、豆包、千问测试SQL语法对错测评对比。结论，这方面豆包靠点谱。

子蛟

33人浏览 · 2026-03-30 09:59:09

子蛟 · 2026-03-30 09:59:09 发布

Deepseek、豆包、千问测试SQL语法对错测评对比。

结论，这方面豆包靠点谱。

// 正确
$path = "../../tmp/123.sql";
$sql = "LOAD DATA LOCAL INFILE '$path' INTO TABLE `tbl` CHARACTER SET utf8mb4 FIELDS TERMINATED BY '#' LINES TERMINATED BY '|'";

// 错误
$path = "../../tmp/123.sql";
$sql = "LOAD DATA LOCAL INFILE  '$path'  CHARACTER SET utf8mb4 INTO TABLE `tal` FIELDS TERMINATED BY '#' LINES TERMINATED BY '|'";