I can't insert data in a table weird error mysql -
hello have table called 'comisiones' described follows:
when try insert new element query:
insert comisiones (id,serial,descripcion,fecha,precio) values (0,"111111111111111","iphone 5 instalacion de aplicaciones","09/06/2016",2000);
i error:
insert comisiones (id,serial,descripcion,fecha,precio) values (0,"111111111111111","iphone 5 instalacion de aplicaciones","09/06/2016",2000)
error code: 1054. unknown column 'fecha' in 'field list'
with show create table comisiones; this:
create table `comisiones` ( `id` int(10) unsigned zerofill not null auto_increment, `serial` varchar(15) collate utf8_spanish_ci not null, `descripcion` varchar(45) collate utf8_spanish_ci not null, `fecha` varchar(10) collate utf8_spanish_ci not null, `precio` int(11) not null, primary key (`id`) ) engine=innodb auto_increment=3 default charset=utf8 collate=utf8_spanish_ci
i answer myself had delete table , create again , working fine
Comments
Post a Comment