MySQL Forums
Forum List  »  Newbie

ERROR 1064 & Error 7
Posted by: Josh Rouwhorst
Date: June 22, 2011 01:55PM

So I'm using the MySql Workbench to add a table and this is the code that the Workbench is trying to execute:
CREATE TABLE `sugarcrm`.`new_table` (
)
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;


This is what I get in response:

ERROR 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 ')
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8' at line 2
SQL Statement:
CREATE TABLE `sugarcrm`.`new_table` (
)
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8


So that's the code that the Workbench came up with itself and it's coming up as incorrect.

The entire reason I'm adding this table is because I'm having issues with altering another table where I'm getting this in a log file: MySQL error 7: Error on rename of '.\sugarcrm\contacts_cstm.MYI' to '.\sugarcrm\#sql2-8ec-12.MYI' (Errcode: 13)

Any help understanding what could cause this would be GREATLY appreciated. Thanks!

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1064 & Error 7
June 22, 2011 01:55PM
June 23, 2011 11:23PM
June 27, 2011 10:00AM


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.