Problems with format parsing when creating tables using the Linux MySQL client

Source: Internet
Author: User

Found in the notepad++ written script, paste to the Linux client, the execution always reported that my script has a problem.

I looked and looked, found that the table script itself is no problem, the problem is on the "tab" key and the top of the note.

The solution is to replace "tab" with a space, and in the text of the comment, add a space to separate it, the script is as follows:

CREATE TABLE Imei_info_harklee  --escalated IMEI data (id  int not  null  auto_increment,  --primary key, self-increment channel  int not  NULL,  --reported channel 1-2015 August 21 Brush out of the number 2-new wiget with the escalation channel of the new, channel dictionary data will also increase. IMEI  varchar (+)  null,imsi varchar (+)  null,plat  varchar (+)  null,  -- Phone model uploaddate  datetime  NULL,   --escalation date, Apache time phonedata  datetime  NULL,-  - Reported cell phone time nettype  varchar (+)  null,  --Network type jspname  varchar (+)  null,  --escalated interface name IP  varchar (+)  null,  --Escalated IP address ver  varchar  null,  --counter version sdkver  varchar (50)  NULL,  --Android SDK version number OS  varchar (+)  null,  --current Android name, e.g. Miuimac  varchar (+)  null ,  --Mobile phone macisroot  varchar ()  NULL,--whether the phone is root 1-root 0-not rootprimary key (ID));

  

Problems with format parsing when creating tables using the Linux MySQL client

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.