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)
![](http://www.learnwebtech.in/wp-content/uploads/2021/03/Screenshot-2021-03-04-at-8.55.50-PM.png)
Increase column size of table
Query: ALTER TABLE student MODIFY email VARCHAR(100) (note: student is a table name)
![](http://www.learnwebtech.in/wp-content/uploads/2021/03/Screenshot-2021-03-04-at-8.57.33-PM-1024x733.png)