If you use PHP program like below... <? $conn = mysql_connect($host,$user,$pass) if(!$conn) exit; mysql_select_db($dbname);
$query = "rename table old_table to new_table"; $res = mysql_query($query, $conn); if(!$res) { echo("Rename table failed"); exit; } echo("Rename table successfully !!!"); ?> It's simple OK ? if you use other programming language, It's similar to above example. Sorry, My english is so poor -_-;; > Is it possible to rename a MySQL table? If so, how? > If not, is there a simple query syntax to copy a table? > I don't have access to the command-line version, > just a web interface, and no, not anything nice like PhpMyAdmin! :-( -- > > Mark Wilson, Computer Programming Unlimited (cpuworks.com) > Web : http://cpuworks.com Tel: 410-549-6006 > Email: [EMAIL PROTECTED] Fax: 410-549-4408 > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]