Ver Mensaje Individual
  #1 (permalink)  
Antiguo 07/06/2005, 14:51
byzard
 
Fecha de Ingreso: agosto-2003
Ubicación: santiago, chile
Mensajes: 303
Antigüedad: 20 años, 9 meses
Puntos: 0
duda, esta bien la sintaxis alter table?

saludos?
estoy probando un modulo, en el cual hay q hacer eso>

ALTER TABLE `ostest`.`products` ADD `products_subimage1` VARCHAR(64) AFTER `products_bimage`
ALTER TABLE `ostest`.`products` ADD `products_bsubimage1` VARCHAR(64) AFTER `products_subimage1`
ALTER TABLE `ostest`.`products` ADD `products_subimage2` VARCHAR(64) AFTER `products_bsubimage1`
ALTER TABLE `ostest`.`products` ADD `products_bsubimage2` VARCHAR(64) AFTER `products_subimage2`
ALTER TABLE `ostest`.`products` ADD `products_subimage3` VARCHAR(64) AFTER `products_bsubimage2`
ALTER TABLE `ostest`.`products` ADD `products_bsubimage3` VARCHAR(64) AFTER `products_subimage3`
ALTER TABLE `ostest`.`products` ADD `products_subimage4` VARCHAR(64) AFTER `products_bsubimage3`
ALTER TABLE `ostest`.`products` ADD `products_bsubimage4` VARCHAR(64) AFTER `products_subimage4`
ALTER TABLE `ostest`.`products` ADD `products_subimage5` VARCHAR(64) AFTER `products_bsubimage4`
ALTER TABLE `ostest`.`products` ADD `products_bsubimage5` VARCHAR(64) AFTER `products_subimage5`
ALTER TABLE `ostest`.`products` ADD `products_subimage6` VARCHAR(64) AFTER `products_bsubimage5`
ALTER TABLE `ostest`.`products` ADD `products_bsubimage6` VARCHAR(64) AFTER `products_subimage6`

pero me sale error de sintaxis,
#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 'ALTER TABLE `ostest`.`products` ADD `products_bsubimage1` VARCH

si no es asi la sintaxis como seria?