MySql tables, error # 1064 and error # 1068 Multiple primary key defined

Question

I got errors when I tried to set MySql tables, error "# 1064 - You have an error in the SQL syntax" and error "# 1068 - Multiple primary key defined": this is db:

CREATE TABLE messages ( msg_id INT PRIMARY KEY AUTO_INCREMENT, message VARCHAR(200), uid_fk INT(10), ip VARCHAR(45), created INT(10), uploads VARCHAR(50), profile_uid INT(10) PRIMARY KEY (`msg_id`), KEY `uid_fk` (`uid_fk`) ); CREATE TABLE comments ( com_id INT PRIMARY KEY AUTO_INCREMENT, comment VARCHAR(200), msg_id_fk INT(10), uid_fk INT(10), ip VARCHAR(45), created INT(10), PRIMARY KEY (`com_id`), KEY `msg_id_fk` (`msg_id_fk`), KEY `uid_fk` (`uid_fk`) ); CREATE TABLE likes ( like_id INT PRIMARY KEY AUTO_INCREMENT, msg_id_fk INT(10), uid_fk INT(10), PRIMARY KEY (`like_id`), KEY `msg_id_fk` (`msg_id_fk`), KEY `uid_fk` (`uid_fk`) ); CREATE TABLE user_uploads ( id INT PRIMARY KEY AUTO_INCREMENT, image_path VARCHAR(500), uid_fk INT(10), PRIMARY KEY (`id`), KEY `uid_fk` (`uid_fk`) ); CREATE TABLE follow_user ( fid INT PRIMARY KEY AUTO_INCREMENT, uid_fk INT(10), following_uid INT(10), PRIMARY KEY (`fid`), KEY `uid_fk` (`uid_fk`) ); 

these are error images:

http://i.stack.imgur.com/3Gb9V.png http://i.stack.imgur.com/G1FOu.png

how to fix it? .. thanks.

Answer 1

Use inline syntax ( msg_id INT PRIMARY KEY AUTO_INCREMENT ) or declare it later ( PRIMARY KEY ( com_id ) ), not both: they conflict.

Answer 2

And the syntax error in the message table is just the missing comma at the end of the profile_uid INT(10) .