CODEWITHSUNDEEP
mysqlsql
Douglas Whetzel
Douglas Whetzel

Reputation: 1

MySQL error 1064 in CREATE TABLE statements in phpMyAdmin

createTable('members', 'user VARCHAR(16), pass VARCHAR(16),
            INDEX(user(6))');

createTable('messages', 
           'id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
            auth VARCHAR(16), recip VARCHAR(16), pm CHAR(1),
            time INT UNSIGNED, message VARCHAR(4096),
            INDEX(auth(6)), INDEX(recip(6))');

createTable('friends', 'user VARCHAR(16), friend VARCHAR(16),
            INDEX(user(6)), INDEX(friend(6))');

createTable('profiles', 'user VARCHAR(16), text VARCHAR(4096),
            INDEX(user(6))');

Can someone please help me figure out what's wrong?

Upvotes: 0

Views: 834

Answers (1)

John Woo
John Woo

Reputation: 263683

Your sql syntax is not correct. try this instead.

CREATE Table `members`
(
    `user` VARCHAR(16), 
    `pass` VARCHAR(16),
    INDEX (`user`)
);

Create Table `messages`
(
    `id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    `auth` VARCHAR(16), 
    `recip` VARCHAR(16), 
    `pm` CHAR(1),
    `time` INT UNSIGNED, 
    `message` VARCHAR(4096),
    INDEX(`auth`, `recip`)
);


CREATE Table `friends`
(
    `user` VARCHAR(16), 
    `friend` VARCHAR(16),
    INDEX(`user`, `friend`)
);

create Table `profiles` 
(
    `user` VARCHAR(16), 
    `text` VARCHAR(4096),
    INDEX(`user`)
);

Upvotes: 1

Related Questions