30/05/2012, 23:22
|
| | Fecha de Ingreso: enero-2008
Mensajes: 303
Antigüedad: 16 años, 9 meses Puntos: 0 | |
Respuesta: intercambiar datos Esta es la estructura:
CREATE TABLE IF NOT EXISTS `temporal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`turno` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
`turnos` varchar(20) COLLATE utf8_spanish_ci NOT NULL,
`lunes` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`martes` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`miercoles` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`jueves` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`viernes` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`sabado` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`domingo` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`saldos` int(2) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=8 ; |