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?
--
most probable is that the auto-inc field is of a type
that will not allow higher values than 127!!
What is the field-type?
\d
-Original Message-
From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]]
Sent: den 15 juni 2001 13:46
To: mysql listserver
Subject: Can only create 127