Member Avatar for rpgwebsolutions

How would you change a column from VARCHAR(10) to VARCHAR(50)?

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by drjohn
Member Avatar for drjohn 
ALTER TABLE tablename
MODIFY columnname VARCHAR(50)

Or if you have phpMyAdmin, select the database, the table, and Structure, then click on the edit icon (the pencil thingy) for the column and just set the new value.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.