Rename a table in MySQL

by

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.

More Related Contents:

  1. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. Throw an error preventing a table update in a MySQL trigger
  5. Is there a MySQL option/feature to track history of changes to records?
  6. Binary Data in MySQL [closed]
  7. Using an Alias in SQL Calculations
  8. Can a table field contain a hyphen?
  9. View’s SELECT contains a subquery in the FROM clause
  10. Check for x consecutive days – given timestamps in database
  11. MySQL Insert Into from one Database in another
  12. How do I get the ID of multiple inserted rows in MySQL?
  13. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  14. Case statement in MySQL
  15. How do I show the schema of a table in a MySQL database?
  16. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  17. MySQL concatenating all columns
  18. Remove special characters from a database field
  19. Proper database model for a user feedback system (an interesting case)
  20. How big can a MySQL database get before performance starts to degrade
  21. MySQL – Replace Character in Columns
  22. FIND_IN_SET with multiple value [duplicate]
  23. How to use a user variables in MySQL LIKE clause?
  24. remove all numeric characters from column mysql
  25. WooCommerce: Finding the products in database
  26. Is it unreasonable to assign a MySQL database to each user on my site?
  27. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  28. Create a new database with MySQL Workbench
  29. Optimistic locking in MySQL
  30. How to search and replace all instances of a string within a database?

Leave a Comment