Change size in mysql query | Alter column size in mysql

Change size in mysql table using query, mean you can increase/decrease, add, modify, delete mysql table columns and columns definition.

Table of content

  • Show Structure of table
  • Increase column size of table

How to show structure of already created table

Query: desc student (note: student is a table name)

Structure of table

Increase column size of table

Query: ALTER TABLE student MODIFY email VARCHAR(100) (note: student is a table name)

Increase column size of table

Pradip Mehta

I am a well-organized professional in Drupal Development and PHP web development with strong script handling knowledge or automation process with PHP. I have advanced computer skills and am a proficient multitasker.