LoginSignup
0
0

A symbol name was expected! A reserved keyword can not be used as a column name without backquotes. (near "varchar" at position 2022)

Posted at

phpmyadmin でCSVファイルをインポートしようとしたらエラー。

エラー
静的解析:

解析中に 3 個のエラーが見つかりました。

  1. A symbol name was expected! A reserved keyword can not be used as a column name without backquotes. (near "varchar" at position 2022)
  2. Unexpected beginning of statement. (near "21" at position 2030)
  3. Unrecognized statement type. (near "DEFAULT CHARACTER SET" at position 2035)

image.png

環境

mysql Ver 15.1 Distrib 10.6.16-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
母艦 Ubuntu22.04 LTS

解決

csv ファイルを見てみたら、CQ列は空のはずだけれども、なにか入っているようだ。

image.png

CQ列を削除して解決。
image.png

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0