MySQL importing database error

Error Message

Análisis estático:

Se encontraron 3 errores durante el análisis.

  1. Tipo de dato desconocido. (near “UNKNOWN” at position 65)
  2. Tipo de dato desconocido. (near “UNKNOWN” at position 181)
  3. Tipo de dato desconocido. (near “UNKNOWN” at position 202)

consulta SQL:

-- Schema for collection: comments CREATE TABLE comments ( _id UNKNOWN, Username VARCHAR(255), Content VARCHAR(255), Avatar VARCHAR(255), Target VARCHAR(255), createdAt UNKNOWN, updatedAt UNKNOWN, __v INT )

MySQL ha dicho: Documentación

#1064 - Algo está equivocado en su sintax cerca ' Username VARCHAR(255), Content VARCHAR(255), Avatar VARCHAR(255), Ta...' en la linea 3

Other Information

I’ve paid some friend on discord to do some website for me, he recommended me this hosting and also teach me how to use it.
So… the thing is that my friend do the website but right now is on vacation and i got this error importing the database he send me, any help? Also sorry if its in spanish.

UNKNOWN is not a valid data type. Replace this with something like TEXT, INT, or VARCHAR(255)

6 Likes
CREATE TABLE comments (
    _id INT,
    Username VARCHAR(255),
    Content VARCHAR(255),
    Avatar VARCHAR(255),
    Target VARCHAR(255),
    createdAt TIMESTAMP,
    updatedAt TIMESTAMP,
    __v INT
)

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.