mysql syntax error [closed]

Question

mysql syntax error [closed]

Navigation

#1 by (2 votes)

-3

Database error

Error: # 1064 - Something is wrong in its syntax near 'source int, refers to varchar (20), results_called int, date_cite date, time_cit' on line 1

Code:

create table Llenado 
    (id int not null primary key AUTO_INCREMENT, nombre varchar(30) not null, 
    a_paterno varchar(20) not null, a_materno varchar(20), 
    telefono int(12), correo varchar, fuente int, refiere varchar(20),
    resul_llamada int, fecha_cita date, hora_cita time, acudio_cita int,
    cubre_perfil int, delegacion varchar(20), edo_civil int, edad int(2), 
    escolaridad int, institucion varchar, carrera varchar, genero int,         
    exp int, colchon int, transporte int, t_disponible int, credito int, 
    pago_credit int, buro int, monto int, imagen int, usuario_seguro int, 
    interesado int, psp int, logro int, energia int, adaptable int, 
    persistente int, tolerante int, sociable int, puntos int, estilo int, 
    ind_rendimiento int, validez int, gte_asignado int, 
    res_entrevista int, motivo_rechazo varchar, pp200 int, estatus int, 
    conexion int, oberservaciones varchar);

mysql sintaxis

asked by Alexis Martinez 20.09.2018 в 15:28

source

1 answer

What is the error? [closed] An array is a sequential list?

score 2 · Answer 1

With this you have it

create table Llenado (id int not null primary key AUTO_INCREMENT, nombre varchar(30) not null, a_paterno varchar(20) not null, a_materno varchar(20), telefono int(12), correo varchar(20), fuente int, refiere varchar(20), resul_llamada int, fecha_cita date, hora_cita time, acudio_cita int, cubre_perfil int, delegacion varchar(20), edo_civil int, edad int(2), escolaridad int, institucion varchar(50), carrera varchar(50), genero int, exp int, colchon int, transporte int, t_disponible int, credito int, pago_credit int, buro int, monto int, imagen int, usuario_seguro int, interesado int, psp int, logro int, energia int, adaptable int, persistente int, tolerante int, sociable int, puntos int, estilo int, ind_rendimiento int, validez int, gte_asignado int, res_entrevista int, motivo_rechazo varchar(50), pp200 int, estatus int, conexion int, oberservaciones varchar(50));

Your problem was that you had not placed a character limit on the varchar