Title / Description
Code <?php $db = mysql_connect('localhost','fdgrup','sDahzLwv'); if(!$db) echo "Cannot connect to the database - incorrect details"; mysql_select_db('redmine'); $result=mysql_query('show tables'); while($tables = mysql_fetch_array($result)) { foreach ($tables as $key => $value) { mysql_query("ALTER TABLE $value COLLATE utf8"); //echo "ALTER TABLE $value COLLATE utf8" ."\n"; }} //echo "The collation of your database has been successfully changed!"; ?>
Author
Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code