Bryan
Bryan

Reputation: 91

MySQL Can't RENAME TABLE

In MySQL,

I want to change my table's name.

For example:

RENAME TABLE old_table to old;

Than I can meet syntax error message.

But:

RENAME TABLE old_table to old_;

It is success.

I don't want to use _(underscore).

Upvotes: 2

Views: 569

Answers (1)

Bhavin Ragha
Bhavin Ragha

Reputation: 73

ALTER TABLE oldTableName rename to newTableName

Upvotes: 1

Related Questions