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)
Increase column size of table
Query: ALTER TABLE student MODIFY email VARCHAR(100) (note: student is a table name)