MySQL Forums
Forum List  »  Newbie

PHPMYADMIN Import from SQL File Errors on TEXT Datatypes
Posted by: Jake Powell
Date: May 27, 2014 03:01PM

CREATE SUB_PROJECTS (
SUB_PROJ_NAME CHAR(30) NOT NULL,
PROJECT CHAR(30),
SUBCODE CHAR(30),
STATE_ABBR CHAR(2),
COUNTY CHAR(),
ACREAGE DECIMAL(13,4),
DESCRIPTION TEXT,
PRIMARY KEY ( SUB_PROJ_NAME )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;


For whatever reason I keep getting an error on importing TEXT fields. I can manually create them via PHPMYADMIN and even did a reverse export to see what the SQL was and it is identical to what I have written here. Any ideas? This is running on a Windows server...which I have a feeling is the issue after some googling but can't find any solutions.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2),
DESCRIPTION TEXT NOT NULL,
PRIMARY KEY ( PROJECT_NAME )
)ENGINE=I' at line 8

Options: ReplyQuote


Subject
Written By
Posted
PHPMYADMIN Import from SQL File Errors on TEXT Datatypes
May 27, 2014 03:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.