It does not let me create the database in phpmyadmin and it gives me this error: # 1064

2

The error he gives me is this:

  

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use   near 'KEY (id))' at line 8

and this is what I programmed:

CREATE DATABASE blog;
USE blog;
CREATE TABLE usuarios (
        id INT NOT NULL AUTO_INCREMENT,
        nombre VARCHAR(25) NOT NULL,
        email VARCHAR(255) NOT NULL,
        password VARCHAR(40) NOT NULL,
        fecha_registro DATETIME NOT NULL,
        activo TINYINT NOT NULL,
        PRYMARY KEY(id)
);
    
asked by refter 08.06.2016 в 14:38
source

1 answer

5

The correct thing is PRIMARY KEY , you have put PRYMARY KEY .

    
answered by 08.06.2016 / 14:42
source