Error 1064 (42000)....

[imaan]

Hello friends,
I received InnoDB syntax error while running mysql 5.0 on OpneBSD 3.9. The commands I used are:

CREATE DATABASE user_accounts;
USE user_accounts;
CREATE TABLE usernames
(
email varchar(40) not null,
password varchar(20) not null,
primary key(email)
)TYPE=INNODB;

Error message: ERROR 1064 (42000): you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to user near ')type=InnoDB' at line 1.

Any help to fix this error would be appreciated greatly.
Thank you! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Reed]

hi, I believe this create table works fine on 5.0.22
Also, replace TYPE=innodb with engine=innodb.
Good luck! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --