How can I modify the size of column in a MySQL table?

by

Have you tried this?

ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(65353);

This will change the col_name‘s type to VARCHAR(65353)

More Related Contents:

  1. Error renaming a column in MySQL
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. 1052: Column ‘id’ in field list is ambiguous
  4. How to do a batch insert in MySQL
  5. Count the occurrences of DISTINCT values
  6. Codeigniter – multiple database connections
  7. Maximum number of records in a MySQL database table
  8. Swapping column values in MySQL
  9. JOIN queries vs multiple queries
  10. Is the primary key automatically indexed in MySQL?
  11. Storing Data in MySQL as JSON
  12. MySql: MyISAM vs. Inno DB! [closed]
  13. Is there a Profiler equivalent for MySql? [closed]
  14. Cast int to varchar
  15. Import SQL file into mysql
  16. How to skip certain database tables with mysqldump?
  17. “where 1=1” statement [duplicate]
  18. How do you debug MySQL stored procedures?
  19. Meaning of “n:m” and “1:n” in database design
  20. How to set a MySQL row to READ-ONLY?
  21. MySQL: LAST_INSERT_ID() returns 0
  22. mySQL – Create a New Table Using Data and Columns from Three Tables
  23. Case Sensitive collation in MySQL
  24. Create an index on a huge MySQL production table without table locking
  25. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  26. Can’t import database through phpmyadmin file size too large
  27. How to change MySQL column definition?
  28. What is the best way to do incremental backups in MySQL?
  29. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  30. How to store data with dynamic number of attributes in a database

Leave a Comment