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]