Jump to content

syntax creating table (date)


voodoochicken

Recommended Posts

hi, i got this error: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 '('yyyy-mm-dd'), identificacion char(13), codigo_pais char(2), tipo_id enum('CC',' at line 8the string i am using to create the table (partial) is something like(...)centro_negocios_lider $def_centro_negocios,fecha_ingreso date('yyyy-mm-dd'),identificacion char(13),codigo_pais char(2),tipo_id $def_tipo_doc,(...)above this is something like $def_tipo_doc = "enum('CC', 'CE', 'NIT')";about the date (fecha_ingreso), i tried both with ' ' and without ' '. how do you declare a date field in the from yyyy-etctnx

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...