duda, esta bien la sintaxis alter table?

[byzard]

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?

[BrujoNic]

Primero... si estas usando la BD, NO tenes que referenciarla, o sea, si en algún lado le diste USE ostest, es más que suficiente para que no pongas la BD seguida de la tabla a usar, eso no afecta pero sale sobrando.

Segundo, quitales esas comillas que NO hacen nada.

Las 2 soluciones quedarían así:

Referenciando la BD:
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

Sin la BD ya que la abriste con USE ostest:
ALTER TABLE products ADD products_subimage1 VARCHAR(64) AFTER products_bimage
ALTER TABLE products ADD products_bsubimage1 VARCHAR(64) AFTER products_subimage1
ALTER TABLE products ADD products_subimage2 VARCHAR(64) AFTER products_bsubimage1
ALTER TABLE products ADD products_bsubimage2 VARCHAR(64) AFTER products_subimage2
ALTER TABLE products ADD products_subimage3 VARCHAR(64) AFTER products_bsubimage2
ALTER TABLE products ADD products_bsubimage3 VARCHAR(64) AFTER products_subimage3
ALTER TABLE products ADD products_subimage4 VARCHAR(64) AFTER products_bsubimage3
ALTER TABLE products ADD products_bsubimage4 VARCHAR(64) AFTER products_subimage4
ALTER TABLE products ADD products_subimage5 VARCHAR(64) AFTER products_bsubimage4
ALTER TABLE products ADD products_bsubimage5 VARCHAR(64) AFTER products_subimage5
ALTER TABLE products ADD products_subimage6 VARCHAR(64) AFTER products_bsubimage5
ALTER TABLE products ADD products_bsubimage6 VARCHAR(64) AFTER products_subimage6

[kikolice]

no faltaria el ";" despues de cada alter? al menos en oracle si es necesario

[darkasecas]

si yo creo que debe ser eso, tambien es necesario en mysql

[susan_]

oigan para mysql y php esta bien esta sintaxis?

Código PHP:

  $agregar="alter table reg_obra add llave char null";  
   

[susan_]

por que no me agrega la columna!

[jurena]

Susan has entrado en un hilo de 2005. No se nos permite revivir hilos antiguos. Abre un nuevo hilo para que te demos una solución.

[BrujoNic]

No se permite revivir temas viejos.

Cerrado.