MySQL script 1064-you has an error in your SQL syntax; Check the manual

Source: Internet
Author: User

SQL data Script import always error (Verify script syntax is correct) "

1064-you has an error in your SQL syntax; Check the manual-corresponds to your MariaDB server version for the right syntax-use near ' DROP TABLE IF EXISTS ' p W_members '; CREATE TABLE ' pw_members ' (' uid ' int (' @ Line 1 ')

The error is that there is an error in the first line.


The problem lies in:

Note that the edit tool in the lower right corner of the prompt "signed", signed files may be created with the TXT of the Windows system text, and this win created text in the header of the file is added to the BOM header (can be seen in hexadecimal), resulting in software read information error.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/85/5B/wKioL1ehZ16iwD9qAAAPurNi-qo522.jpg-wh_500x0-wm_3 -wmp_4-s_3331702326.jpg "title=" qq20160803113726.jpg "alt=" Wkiol1ehz16iwd9qaaapurni-qo522.jpg-wh_50 "/>

Workaround:

After you open the Text tool with EmEditor or notaped, save as a copy. Note Save Select "No signature".

UTF-8 coding is based on your actual choice.

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/85/5C/wKiom1ehaH-B0K7vAAAX8PUdewg995.jpg-wh_500x0-wm_3 -wmp_4-s_148158347.jpg "title=" qq20160803114335.jpg "alt=" Wkiom1ehah-b0k7vaaax8pudewg995.jpg-wh_50 "/>

This article is from the "Enlightened Grocery store" blog, please be sure to keep this source http://wutou.blog.51cto.com/615096/1833894

MySQL script 1064-you has an error in your SQL syntax; Check the manual

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.