I can't insert data in a table weird error mysql -


hello have table called 'comisiones' described follows: enter image description here

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

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

android - Robolectric "INTERNET permission is required" -

java - Android raising EPERM (Operation not permitted) when attempting to send UDP packet after network connection -