MySQL type = MyISAM error

Question

I am working on my forum site earlier this month and run into a small problem. Unfortunately, everything went smoothly, with the exception of my database. I made a table in it called usersusing this script ...

CREATE TABLE `users` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(65) NOT NULL default '',
`password` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

However, when I tried to run the code, I get this error ...

# 1064 - You have an error in the SQL syntax; check the manual corresponding to the version of MySQL server, for the correct syntax use about 'TYPE = MyISAM AUTO_INCREMENT = 2' on line 6

I communicated with this before by running it from Engine, but this time I got two different errors.

, MySQL , MySQL , . MySQL , .

- /. , , , , localhost. , - , , , .

, , . .

Answer 1

  TYPE=MyISAM

 ENGINE=MyISAM

TYPE MySQL 4.0 MySQL 5.5.

http://dev.mysql.com/doc/refman/5.6/en/create-table.html

Answer 2

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;