Try this;
ALTER TABLE old_table_name RENAME TO new_table_foobar
\david
-----Original Message-----
From: Michael Ott [mailto:[EMAIL PROTECTED]]
Sent: den 27 juni 2001 09:19
To: MySQL-Mailing-List
Subject: rename table
hallo
i want to change the name of a table. what must i do?
--
Gruß & bye
Michael Ott
---------------------------------
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen -
- Tel. +49 91 31 7 42 0 54 -
- [EMAIL PROTECTED] -
---------------------------------
open-source and you have much fun
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php