MySQL导入错误:未知的标点字符串 [英] MySQL Import ERROR: Unknown Punctuation String

问题描述

当尝试使用phpMyAdmin导入MySQL数据库时，出现以下错误.我不确定转储是如何创建的:

I get the following error when trying to import a MySQL database with phpMyAdmin. I am not sure how the dump was created:

您的SQL查询中似乎有一个错误.下面的MySQL服务器错误输出(如果有的话)也可以帮助您诊断问题

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 108
STR: |//**
SQL: -- Database lach

    -- Table structure for table jos_acajoom_lists

|------
|Field|Type|Null|Default
|------
|//**id**//|int(10)|Yes|NULL
|**list_name**|varchar(101)|Yes|
|list_desc|text|Yes|NULL
|list_type|tinyint(2)|Yes|0
|sendername|varchar(64)|Yes|
|senderemail|varchar(64)|Yes|
|bounceadres|varchar(64)|Yes|
|layout|text|Yes|NULL

推荐答案

您似乎正在尝试使用"//"注释掉导入中的一行.您将需要用-"替换它，因为MySQL不支持C ++样式注释.

It looks like you might be trying to use a "//" to comment out a line in the import. You will need to replace that with "-- ", as MySQL does not support the C++ style comments.

这篇关于MySQL导入错误:未知的标点字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！