Where is the error in the SQL command to create the table?

Question

MySQL

Error while executing the script:

CREATE TABLE users (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    login NOT NULL PRIMARY KEY VARCHAR(255), 
    password NOT NULL PRIMARY KEY VARCHAR(255)
);

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 use near 'NOT NULL PRIMARY KEY VARCHAR(255)
, password NOT NULL PRIMARY KEY VARCHAR(255))' at line 1

Answer 1

First - not NOT NULL VARCHAR, but VARCHAR NOT NULL. Second, there can only be one primary key.
I think you meant this:

CREATE TABLE users (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    login VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
);