Error renaming a column in MySQL

by

Lone Ranger is very close… in fact, you also need to specify the datatype of the renamed column. For example:

ALTER TABLE `xyz` CHANGE `manufacurerid` `manufacturerid` INT;

Remember :

  • Replace INT with whatever your column data type is (REQUIRED)
  • Tilde/ Backtick (`) is optional

More Related Contents:

  1. How can I modify the size of column in a MySQL table?
  2. Which DB technology is sued to solve the following search issue? [closed]
  3. MyISAM versus InnoDB [closed]
  4. Compare two MySQL databases [closed]
  5. How should I resolve –secure-file-priv in MySQL?
  6. What does character set and collation mean exactly?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing image in database directly or as base64 data?
  9. Implementation of Levenshtein distance for mysql/fuzzy search?
  10. Does MySQL index foreign key columns automatically?
  11. What’s the difference between MyISAM and InnoDB? [duplicate]
  12. MySQL: ALTER TABLE if column not exists
  13. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  14. In SQL, is it OK for two tables to refer to each other?
  15. MySQL SELECT increment counter
  16. Hyphens in column names in MySQL DB
  17. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  18. Modeling Product Variants
  19. Mysql database sync between two databases
  20. MySQL Insert Into from one Database in another
  21. What’s the best database structure to keep multilingual data? [duplicate]
  22. Does mysql have the equivalent of Oracle’s “analytic functions”?
  23. Using reserved words in column names
  24. FIND_IN_SET with multiple value [duplicate]
  25. What is the difference between SQL and MySQL? [closed]
  26. mysql Failed to read auto-increment value from storage engine
  27. Alter table if exists or create if doesn’t
  28. Selecting distinct 2 columns combination in mysql
  29. Inventory management with stock options
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment