Jump to content

syntax creating table (date)


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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...