Quiero ingresar estos datos a mi BD y me sale el error que salgo mas abajo
Código PHP:
CREATE TABLE `informacion` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`empresa` varchar(40) NOT NULL,
`actividad` varchar(40) NOT NULL,
`grupo` varchar(20) NOT NULL,
`telefono` varchar(15) NULL,
`localidad` varchar(40) NOT NULL,
`pais` varchar(30) NOT NULL,
`web` varchar(40) NULL,
`contacto` varchar(40) NULL,
`email` varchar(45) CHARACTER SET utf8 COLLATE utf8_spanish_ci default NOT NULL,
PRIMARY KEY (`id`)
)
Código PHP:
#1064 - 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 'NOT NULL,
PRIMARY KEY (`id`)
) at line 21