<?php
$nombre_tabla = 'princessitinerarios' ;
switch($nombre_tabla) {
case 'princesscruceros':
$sql = ["ALTER TABLE `princesscruceros` ADD INDEX ( `codigo_de_crucero` ) ;",
"ALTER TABLE `princesscruceros` ADD INDEX ( `codigo_de_barco` ) ;"
];
break;
case 'princessitinerarios':
$sql = ["ALTER TABLE `princessitinerarios` ADD INDEX ( `codigo_puerto` ) ;",
"ALTER TABLE `princessitinerarios` ADD INDEX ( `codigo_de_crucero` ) ;",
"ALTER TABLE `princessitinerarios` ADD INDEX ( `nombre_del_crucero` ) ;"
];
break;
case 'princesscodigosdepuertos':
$sql = ["ALTER TABLE `princesscodigosdepuertos` ADD INDEX ( `codigo_de_puerto` ) ;"];
break;
}
var_dump($sql);
- Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- array(3) {
[0]=>
string(67) "ALTER TABLE `princessitinerarios` ADD INDEX ( `codigo_puerto` ) ;"
[1]=>
string(71) "ALTER TABLE `princessitinerarios` ADD INDEX ( `codigo_de_crucero` ) ;"
[2]=>
string(72) "ALTER TABLE `princessitinerarios` ADD INDEX ( `nombre_del_crucero` ) ;"
}
- Output for 4.4.2 - 4.4.9, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29
- Parse error: syntax error, unexpected '[' in /in/hofjN on line 6
Process exited with code 255. - Output for 4.3.0 - 4.3.1, 4.3.5 - 4.3.11, 4.4.0 - 4.4.1, 5.0.0 - 5.0.5
- Parse error: parse error, unexpected '[' in /in/hofjN on line 6
Process exited with code 255. - Output for 4.3.2 - 4.3.4
- Parse error: parse error in /in/hofjN on line 6
Process exited with code 255.
preferences:
257.98 ms | 401 KiB | 400 Q