Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Rename a table in MySQL

Tags:

database

mysql

table-rename

Renaming a table is not working in MySQL

RENAME TABLE group TO member;

The error message is

#1064 - You have an error in your SQL syntax; check the manual that corresponds         to your MySQL server version for the right syntax to use near 'group          RENAME TO member' at line 1

The query is working fine on other tables for me, but not with the table group.

like image 441
Anil Olakkal Avatar asked Sep 29 '12 06:09

Anil Olakkal

People also ask

Can we rename database in MySQL?

Rename MySQL Database from Command Line Log into the server, and open a command line / terminal window. (If you're working remotely, connect to the server via SSH.) Replace [UserName] and [Password] with the actual credentials for the database, and replace [DB_Name] with the exact name of the database you're changing.

Can we rename the table name?

Any database user can easily change the name by using the RENAME TABLE and ALTER TABLE statement in Structured Query Language. The RENAME TABLE and ALTER TABLE syntax help in changing the name of the table.

1 Answers

group is a keyword (part of GROUP BY) in MySQL, you need to surround it with backticks to show MySQL that you want it interpreted as a table name:

RENAME TABLE `group` TO `member`;

added(see comments)- Those are not single quotes.

like image 79
Joachim Isaksson Avatar answered Sep 17 '22 16:09

Joachim Isaksson
Sign in to Comment

Related questions

What MySQL data type should be used for Latitude/Longitude with 8 decimal places?
SQL keys, MUL vs PRI vs UNI
MySQL SELECT only not null values
ROW_NUMBER() in MySQL
MySQL Orderby a number, Nulls last
Install MySQL on Ubuntu without a password prompt
For homebrew mysql installs, where's my.cnf?
How can I modify the size of column in a MySQL table?
MySQL LIKE IN()?
Best data type to store money values in MySQL
Cast from VARCHAR to INT - MySQL
grant remote access of MySQL database from any IP address
Get table names using SELECT statement in MySQL
JSON encode MySQL results
Table 'performance_schema.session_variables' doesn't exist
How to best display in Terminal a MySQL SELECT returning too many fields?
Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL?
How to get the max of two values in MySQL?
Best practices for SQL varchar column length [closed]
MySQL query to get column names?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!