alter * ( all tables) ???

[geeOff]

does anyone know if there is a way to alter all tables in a DB ? i want to rename all the "partial" columns to "part_credit" like so:

ALTER TABLE `grades`.`u10s2` CHANGE `partial` `part_credit` TINYINT(4) DEFAULT '0' NOT NULL 

it seems that the word 'partial' is a reserved word with mySQL.

Geoff

[DR_LaRRY_PEpPeR]

nope, i don't think there is. you'll have to do each manually.

[Defender1]

Best solution would to try and run it through a loop to save you having to manually change each.

[Paul S]

Originally posted by geeOff
it seems that the word 'partial' is a reserved word with mySQL.

Yes it is.

In pseudo php code, this is what Defender is suggesting,

<?
$tables = get_all_tables('yourdatabase');

foreach ($tables as $table) {

 $sql = "ALTER TABLE $table CHANGE `partial` `part_credit` TINYINT(4) DEFAULT '0' NOT NULL";

 mysql_query($sql);
}?>