bulk_change_field_names.php

<?php
    //copyright fred.trotter@gmail.com
    //Not Only Development, LLC 2012
    //Licensed under the same license as Sequelize
    //https://github.com/sdepold/sequelize/blob/master/LICENSE

    $yaml_file = 'config.yaml';

    if (function_exists('yaml_parse_file')) { //then we are using PECL..
        $config = yaml_parse_file($yaml_file);
    } else {
        echo 'use pecl to install php yaml';
        exit();
    }
    $user = $config['user'];
    $password = $config['password'];
    $database = $config['database'];
    mysql_connect($config['host'], $user, $password);
    mysql_select_db($database);

    $tables_sql = 'SHOW TABLES';

    $result = mysql_query($tables_sql) or die("arrgh... my eye!!! $tables_sql");

    $fields_to_change = [
        'createdAt' => ['to' => 'created_at',
                    'type'   => 'DATETIME NOT NULL', ],
        'updatedAt' => ['to' => 'updated_at',
                    'type'   => 'DATETIME NOT NULL', ],
        ];

    foreach ($fields_to_change as $from => $to_array) {
        $to = $to_array['to'];
        $type = $to_array['type'];

        while ($row = mysql_fetch_array($result)) {
            $this_table = $row[0];

            $sql = "ALTER TABLE  `$this_table` CHANGE  `$from`  `$to` $type";
            echo "$sql \n";
            if (!mysql_query($sql)) {
                echo 'Error with: '.mysql_error()."\n";
            } else {
                echo "$this_table changed\n";
            }
        }//end while
    }//end foreach