Help with creating SQLITE3 tables

Navigation
0

I have an error with the following query of my table in sqlite3: 

Create table EmpleadosCursos(
Empleado constraint fk1_empleadoscursos references empleados,
Curso constraint fk2_empleadoscursos references cursos,
constraint pk_empleadoscursos primary key(empleado,curso),
fecha date);

The error:

  

Error: near "date": syntax error

    
asked by Agustin Lyon 10.12.2018 в 18:59
source

1 answer

0

I understand that sqlite does not have the data type Date , but only the following:

  

INTEGER, TEXT, BLOB, REAL and NUMERIC.

    
answered by 09.01.2019 в 18:55
InnerHTML angular 5 does not respect width I can not send my data from a dynamic table in C # mvc