1

I am trying to run:

CREATE TABLE `members` (
`id` int(11) NOT NULL auto_increment,
`users` text NOT NULL,
`password` text NOT NULL,
`ip` text NOT NULL,
`status`text NOT NULL,
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

I just can't seem to find the error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 8

closed as off-topic by Mark Storey-Smith, Paul White, ypercubeᵀᴹ, RLF, Max Vernon Oct 14 '14 at 13:30

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Mark Storey-Smith, Paul White, ypercubeᵀᴹ, RLF, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.

3

From here, replace TYPE=MYISAM with ENGINE=MYISAM.

This used to be acceptable syntax, but has been deprecated and removed in 5.5 (from the same thread).