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